Re: Import from Excel Question

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Heather,
The wizard does not allow you to specify columns.
You could write a lot of code to automate Excel and then do anything you can
think of in terms of importing the data. But it is much harder.

Some obvious choices are:
1. Edit the spread*** and have it only include the columns you need.
(You could write a macro to do tihs if the original *** was always in the
same layout.)

2. Import all the columns to a "staging table" in Access (just a regular
table but not one that is part of your main application - it is used to hlld
the imported data and is cleared out - by yur code - every time you import
something else.)
Then write a query to Append the staged data to your real table. The query
will only contain the columns you want.

I recommend #2.
--
Joe Fallon
Access MVP



"HeatherD25" <HeatherD25@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:960A0E53-DC67-4D67-9C5D-8132EC4FC400@xxxxxxxxxxxxxxxx
> I'm sure there's an easy answer to this, but I can't figure it out. I
> want
> to import data from Excel into an Access database. But, the data columns
> in
> Excel aren't in the same order they are in Access, and I don't want to
> import
> all of them. Is there a way to specify which columns I want to import
> from
> Excel?
>
> Thank you!!
> Heather


.

Quantcast