Excel spreadsheet import problem

K

Ken Warthen

I'm trying to import an Excel spreadsheet into an Access 2007 table. I've
tried using the TransferSpreadsheet command, but get an error saying the
spreadsheet doesn't exist. As a check I tried manually importing the
spreadsheet using an Access Wizard. The Wizard imports the data into a table
but when I try to view the table it only displays the first four records (of
64,221 total records).

Anybody have a similar issue, and if so, how did you resolve it?

TIA,

Ken
 

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

Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Integrating information from Word to Excel (not mail merge) 1
Access 2003 versus Access 2007 Excel Import 0
Linking data in MS Word into Excel 5
TransferSpreadsheet question 2
Transferspreadsheet import conflict 3
Import Excel check field names Please Help 2
Excel to Word to PDF workflow 1

Top