import error into Access 2003 with Excel 2003

S

san_quentin76

I'm encountering a situation whereby I'm importing an Excel file into Access
that is at its limit or capacity of rows and when I import the spreadsheet
into Access as a table it splits the database thereby leaving me with missing
records. I tried using the following code to import two different tables and
it captured all of the data from two different worksheets. However I tried
to unify the tables with an append query and Access 2003 cut off a few
thousand records once again. Any suggestions?

Sub import()
DoCmd.TransferSpreadsheet acImport, , "tblImport1",
"C:\Databases\pur_rpt_ncr1.xls", False, "A2:N65536"
End Sub
 

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

Access 2003 versus Access 2007 Excel Import 0
Import Excel named range into Access 2
How can I import an unstandard Excel worksheet into Access 2007? 3
VBA for Access, import Excell files into Access tables 5
Import from Excel 2003 to Access 2003 4
How to assure a "TransferSpreadsheet" import goes to desired Table 0
Error while import Excel file to Access 6
Export Report with Graph to Excel error 2495 1

Top