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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brook - 25 Aug 2005 04:36 GMT

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

Reply to this Message

Roger Carlson - 25 Aug 2005 20:10 GMT

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.

Signature

--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

> good Day all,
>
[quoted text clipped - 9 lines]
>
> Brook

Reply to this Message