5 replies
by rogerndgreen
How are you tring to convert Excel to Access? You won't be able to do it if all you do is save "Book1.xls" as "book1.mdb".
Try saving the excel spreadsheet as a CSV (comma separated variable) text file, and then in Access, use Get external data, from text file.
I no longer use Office 97 (I was forced into the upgrade to 2000), and so I don't know if Access 97 gives you the option to import directly from an Excel spreadsheet, or how succcessful it really is, if it should support it.
It certainly works in 2000.
Hope this helps
Roger
by dave.raj
hm. strange. tried - everythin fine.
1. start MS Access
2. Create new blank database
3. Select File->Get External Data->Import, choose here, change Files of Type to Excel, select your xls file and answer to Wizard questions.
by dave.raj
by dave.raj
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending