Importing an Excel Comma Separated Values File into Microsoft Access. 1

[Really]

How do I import an excel CSV file into an Access database form.

I designed a form in Access and I created a command button. Whenever I click on the command button, I want the command button to access the file located in c:\work\test.csv, get the information in the test.csv file and use it to populate the fields in my form. I DO NOT want to open this excel file, but I want the value in this excel file to get POPULATED in the fields in my Access Form.

What's the best and simple way to do this. My Excel version is 97 and my Access version is also 97.

Thank YOU.

 

[p27br]

Hi ,

You must first import the file once manually with the import wizard.
When you get to the last window of the wizard, you must click the "advanced" button and then "save as" and give the import specification a name.
Then you create an event procedure for your button. Type the command
sub button1_onclick

docmd.TransferText acImportDelim,"SpecName","tablename","filename" = full path

end sub