By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,805 Members | 1,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,805 IT Pros & Developers. It's quick & easy.

transferspreadsheet dropping a row

P: n/a

We've been using a macro to import Excel spreadsheets into an access 2002
database. After 5 months of this we found an error on a report. It turns out
that access is ignoring the last row and last column of the spreadsheet. If
the spreadsheet has 12 columns and 1000 rows the table will have 11 columns
and 998 rows of data (one row is converted to field names). This happens
when using Transferspreadsheet in a macro and in VBA. The same result is
produced when using the wizard to get external data. We also discovered that
if we open the spreadsheet and save it (even without making a change) the
missing row and column will be imported correctly. I would imagine that when
we save it, it is saved with a different version of Excel than it was
created with. However, I can't imagine how Access would let this happen. By
the way, the spreadsheets come via internet from a third party. We have no
control over what they use to create it. We'd greatly appreciate any ideas.

We're running Access 2002 SP3 Excel 2002 SP3 VB 6.3

Aug 11 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.