Uploading data from .xls to .mdb (and not from .mdb to .xls)

M

Mallory

I want to export data from .xls or .txt files directly
into a given Access table by VB (I know the other way
round is possible but don't want to use it).
Does sbdy knoww how to proceed ?
 
B

Bill Barclift

Yes, this is very common and can be done using ADO. I believe if you search
the knowledge base at Microsoft you will find an article on this.

Bill Barclift
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Write EXCEL files from a FORTRAN Program ? 0
Checking limit values from separate xls file 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Creating a Chart on form from selected data in query. 0
mdb - > xls 5
Adding data to MS Access from csv file 0
XLT vs XLS 8
Copy selected columns from .xls to a .txt file question 4

Top