|
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.
Thanks.
We're running Access 2002 SP3 Excel 2002 SP3 VB 6.3
| 
