create a command button to import .csv file into temp tbl?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

good Day all,

I currently download, and manually delete the information in
tmptblaccountinfo, then manually import new data (.csv file) into the table,
then manually run a qryupdateaccount. I download and save my file to
c:\banking and is saved as a date file (i.e. 08242005.csv).

Can anyone help me set this up so that I can perform the operations with
the click of a command button.?

Thanks in advance..

Brook
 
On my website (www.rogersaccesslibrary.com) there are several small Access
database samples that might help. Mostly they start with "Update" or
"Import" or "Export". I don't have anything that is directly on point, but
most of them use the same technique called Low Level I/O to read the file
line by line in tot he database and then create an export in the reverse
process.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top