Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Import a .xlsx file into a MS Access 2000 .mdb table
10 views
Skip to first unread message
Chuck
Nov 10, 2009, 10:31:17 PM11/10/09
to
I have an Access 2000 database that imports an Excell worksheet using
transferspreadsheet. The source of the worksheet changed from Excel 2000 to
2007. Now I receive the error that it is an unexpected format. Is there a way
to import the worksheet without upgrading Access to 2007?
Thanks
transferspreadsheet. The source of the worksheet changed from Excel 2000 to
2007. Now I receive the error that it is an unexpected format. Is there a way
to import the worksheet without upgrading Access to 2007?
Thanks
Tom van Stiphout
Nov 10, 2009, 11:53:02 PM11/10/09
to
On Tue, 10 Nov 2009 19:31:17 -0800, Chuck
<Ch...@discussions.microsoft.com> wrote:
<Ch...@discussions.microsoft.com> wrote:
Software is rarely forward compatible. In the year 2000 or before
(they probably worked on Excel2000 in 1998-99) there was no concept
yet of what Excel would be like 8 years later.
Can you export to CSV, then import to Excel2007?
-Tom.
Microsoft Access MVP
0 new messages