Community archive

Ask something
Discussion Locked

Can't convert Excel 2000 to Access 95

0 helpful
11 replies

by schoing

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm in a firm that just got all of OFFICE 2000 except "ACCESS". The reason why Access did not get converted is because other departments still has OFFICE 95. So remains ACCESS 95 in and environment with OFFICE 2000. My problem is I have a user who uses excel 2000 and is trying to merge it with access 95. When he does this an error would pop up that says something about "you're running VISUAL Basic and the Path is wrong".
Some of the things I tried is opening excel 2000 and saving it as excel 95. Then I would open ACCESS 95 and try to convert the Excel 95 to ACCESS 95. Still gives the same error. Another thing I did was enabled Macros in excel when I first open the spreadsheet. Help this one really got me and the team.

11 replies

by enzobeast

Have you tried saving it as a tab delimited text file and then importing it into access '95?

by otl

Answer #1 is the only logical way to upgrade from 95 to 2000.

A major cross-converter!

by frescalus

In the save as dialog box pull down the "Save As Type" List and you will see "Microsoft Excell 5.0/95 Workbook. Select that, then type the name of the file. Then open Access 95 and perform the action you are trying to do. If that doesn't work, upgrade.

Hope that helps.

by yatst

I would concur with Answers 1 and 2. I've been using Access since 2.0. Save your excel file as a text file or *.txt. Then import the file into MS Access 95.

If the info needs updating you can link the *.txt file to excel and Link instead importing the *.txt file in MS Access. Good Luck

This discussion is closed to new replies.