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

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 ?

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

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

"Mallory" wrote in message
...
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 ?

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

For XL to Access, TransferSpreadsheet method will do the trick.


"Mallory" wrote in message
...
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 ?