importing a CS text file into a table

[westonwheat]

I know this is very basic, but I am new to Access 2000.
Anyway, I have a Access 2000 database, that I need to import numberical values from a CS text file (from a floppy drive)into a table.
I done this before in Access 2.0 using msau200.dll calls but I am not familiar with how to get the API calls to work for Access 2000 or what API calls I need.
Thanks.

 

[vbajock]

What's a CS text file?

 

[kewo99]

I think you're refering to a CSV file, right?
If so -- why don't you just use the import wizard to create a table?

Ken

 

[westonwheat]

Yes I do mean CSV file. And I need to be to import into the same table each time. I work at thermistor manufacturer and the goal is to have the operators take the data from the test stations which format the raw data on the CSV file. Then we want to tranfer it to a Access database table. So we will have up 10 sets of data for the same lot. We want all of this data to be on one large table. I hope that help in where I am coming from.
Thanks.

 

[kewo99]

Use the Import wizard 1 time and create an Import Specification for your file (click the Advanced button) to specify what goes where, formats, etc.
After that you can use the TransferText method:

DoCmd.TransferText,,,,,,,, (lookup TransferText in Help for the exact syntax).

Put this in the On Click event of a button or run it from a macro.

Ken