Discussion Locked

Database conversion

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

My company is currently running a database created with Lotus Approach 97 and I now have the task or creating a new database in MS access 2000. I want to be able to import all the current data in to thhis new database but so far have been unsuccesful

CAN ANYBODY OUT THER HELP ME.

3 replies

by dle

From within Lotus Approach are you able to save/export the data to a comma delimited text file (.csv or .txt)? Or perhaps export the data to a Lotus 123 spreadsheet? MS Access is able to import the data into a table from any of the mentioned file formats.

by addison99

thanx this worked fine but can u help me further

Access has created another ID field and I want to continue to use the Id field created in Approach.

This discussion is closed to new replies.