Import Selected Data

[Ernst Guckel]

Hello,

I am importing data from a CSV file that has 81 fields of data. I am
trying to only import 14 fields but they are not together... but scattered
across the dataset. I see that access will allow me to skip data import on
selected fields but the field list it gives me looks like it refers to the
destination table (by the field names) and not the source CSV file. Do I
have to count out the fields and say don't import 'Field3' even though the
field list has it named 'EmpDiscounts' I want that data...

Ernst.

 

[Jeanette Cunningham]

Ernst,
in the import wizard, by default, all fields are imported.
If there are some fields in the csv you don't want, you need to select each
one you don't want and mark it as don't import.

If you are importing to a new table, it is just as easy to import all fields
and then use a query to append just the results you want to your table.

If you just want certain fields, you must de-select those fields you don't
want.
To import to your existing table, the csv field names will need to match
your table field names.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Wayne-I-M]

HI

Best bet would be to import the whole thing into a temp table - run an
update query for just the fields you want then delete the temp. Can all be
done "On-Click" of a single button with a bit of vba. The reason for this is
that it will allow you to simply add field to the update as and when you want
in the future.