You can make an import spec & skip the fields that way - or - import into a
temp table & run an Append query on that
Pieter
> Hi everyone,
>
[quoted text clipped - 9 lines]
>
> Dave B
the import wizard lets you exclude columns during a import....
file->get external data->import
when the wizard starts, select comma, delimiters etc....
Then hit the advanced button..you see a check mark to include only the
fields you want...
So, once you get this working via a manual process, then you can save this
'advanced' setting, and make the whole process a one button click affair
(note the "save-as" buttion in the advanced setting, this is how you "save"
your import spec..and once done, you can use this with the transfertext
command to automate the import).
So, take this one step at a time, save the import spec, and get the text
import working the way you want...

Signature
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
Dave - 13 Sep 2007 12:48 GMT
On Sep 12, 9:18 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
> the import wizard lets you exclude columns during a import....
>
[quoted text clipped - 18 lines]
> Edmonton, Alberta Canada
> pleaseNOOSpamKal...@msn.com
Thanks Albert, you're always so helpful.
How about if it is an excel spreadsheet instead of a csv file. Is
there a way to automate the import of that? I found out that the
instrument output that I'm interested in importing to my database,
exports as a excel file, not text unfortunately.
Thanks,
Dave B
Pieter Wijnen - 13 Sep 2007 15:59 GMT
I think you have to use a temporary table (or link to the spreadsheet)
& import to the real table using a Query
Pieter
> On Sep 12, 9:18 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
> wrote:
[quoted text clipped - 33 lines]
>
> Dave B