Originally posted by tinkxtheminx
i need my vba front end of access to allow a user to point to a csv file and allow them to upload this data to a table. can this be done and can any1 give me an idea of where to start.
thankx in advance
You can use DoCmd.TransferText acImportDelim, "Standard Output", _
"External Report", "C:\Txtfiles\April.doc" for example to import a text file. You could use ADO as well. Both these methods will import the data in bulk. If you wanted to verify the data as it is imported you could use the Windows Scripting object to go through each line in a text file and import it into a table.