Import Excel Worksheet into an Access Database 
Author Message
 Import Excel Worksheet into an Access Database


How do you import a worksheet into an Access table using VB6. I am able
to get the file path through the use of the commondialog control but can
not select the sheet i want to import. Any help would be appreciated.


Mon, 09 Feb 2004 03:53:46 GMT  
 Import Excel Worksheet into an Access Database
The easiest way is via Access automation; basically, you open access, and
your database, and then use the DoCmd.TransferSpreadsheet macro to bring in
the spreadsheet.

The TransferSpreadsheet lets you specify the range or worksheet name.

Hope this helps!

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

Mon, 09 Feb 2004 05:58:03 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Import multiple excel files with inconsistent number of worksheets in each into ACCESS

2. VB 4.0 Importing Data from Excel Worksheet into Access 2.0

3. Import Excel Worksheet(2)

4. Importing an Excel Worksheet

5. Import Excel worksheets via VB and DAO?

6. Newby question: import Excel worksheet

7. Newby question: import Excel worksheet

8. Importing Excel File in Access Database

9. Enumerating Excel worksheets within Access

10. Exporting Access tbl to Excel - Worksheet Names

11. Access/VBA: Creating New Excel Worksheets?

12. Linked Excel worksheet losing data. Access table OK


Powered by phpBB® Forum Software