Hi everyone,

You've been a great help to me in the past. I hope someone can here
too.

I have a database to which I would like to import data from a csv
file. Each csv file has about 30 different fields separated by commas.
I want to add only two of those fields to my database. How do I do
this? Or does somebody know of a tutorial that might help?

Thanks,

Dave B

You can make an import spec & skip the fields that way - or - import into a 
temp table & run an Append query on that

Pieter

"Dave" <Dave.Beaune@lhsc.on.ca> wrote in message 
news:1189619066.742172.291810@g4g2000hsf.googlegroups.com...
> Hi everyone,
>
> You've been a great help to me in the past. I hope someone can here
> too.
>
> I have a database to which I would like to import data from a csv
> file. Each csv file has about 30 different fields separated by commas.
> I want to add only two of those fields to my database. How do I do
> this? Or does somebody know of a tutorial that might help?
>
> Thanks,
>
> 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...


-- 
Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

On Sep 12, 9:18 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
> 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...
>
> --
> Albert D. Kallal    (Access MVP)
> 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

I think you have to use a temporary table (or link to the spreadsheet)
& import to the real table using a Query

Pieter

"Dave" <Dave.Beaune@lhsc.on.ca> wrote in message 
news:1189684118.796354.38360@d55g2000hsg.googlegroups.com...
> On Sep 12, 9:18 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
> wrote:
>> 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...
>>
>> --
>> Albert D. Kallal    (Access MVP)
>> 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
>