| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Uploading reports into excel | Excel Worksheet Functions | |||
| Uploading ASCI | Excel Worksheet Functions | |||
| Uploading Excel to web site | Excel Discussion (Misc queries) | |||
| Uploading data to an Ingres Db from excel | Excel Discussion (Misc queries) | |||
| Automatic comparison and uploading of data among 2 spread sheets | New Users to Excel | |||
Linear Mode
