Discussion Locked

Problem with Excel 97 and Access 97

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, I know I am in the wrong section but I am bit stumped with this problem. I am trying to convert a file in Excel into Access and it doesn't happen. It shows the file has been created, but no data resides in it. Also In Access can't get external data from an Excel file, it doesn't give you an option to choose an Excel file. I have deleted Office 97 and re-installed and it still has not solved the problem.I have done all the add ins and it doesn't work. Can somebody please help?Thankyou

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 sergey kovzik

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.

This discussion is closed to new replies.