macro for importing table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to use a macro to import a table from Excel. Coulf anyone advise
a good strategy?
 
Allen_N said:
I would like to use a macro to import a table from Excel. Coulf anyone advise
a good strategy?
Click to expand...
Try to steer clear of macros. VBA is much the way to go. Try this.

Dim strPathName As String

strPathName = "PathName.XLS"


DoCmd.TransferSpreadsheet acImport, 8, "ZZ", strPathName, False, ""
 
Okay, now it gets curly: my workbook has more than 1 sheet (because the data
exceeded 65,536 records), and the TransferSpreadsheet action only imports the
1st one.

I have written an ActiveX routine to pass the number of sheets in the
workbook to my Access VBA routine, but all I can think of to do at the moment
is to warn the user that sheets after the 1st one must be imported manually.
Is there a way to automate this?
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing any excel files with any sheet name into different tables in MSAccess using code 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to export table from outlook into ms access table? 0
How to Create a Macro to Import External Data 0
Import Text File Into Access 0
Temp DBs 2
Deleting Import Error Tables 3

Back
Top