General discussion

Locked

Get to Access 2000 data via Access 97?

By wordworker ·
Hey guys, I have a client who had a "pipe" built that periodically dumps data from an SQL/Web server down to a database on a local PC. The problem? It's dumped in Access 2000 MDB format. The client only has Access 97... I tried creating an ODBC workspace in A97 but couldn't get it to link to the A2K file. (The client had updated Jet engine, though to my read it looked like the Jet update wasn't intended for Access 97.) So...If I create an MDE in Access 2000 with the same tables as the data dump from the Web server, will the MDE let me import/link to the data in that other MDB? Any other suggestions for getting to that data using Access 97 or the like?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Get to Access 2000 data v ...

The data will either have to be saved in A97 format, or exported as CSV, XLS etc.

Collapse -

by wordworker In reply to

Poster rated this answer.

Collapse -

by RichTee In reply to Get to Access 2000 data v ...

You will not have a problem linking to or importing from the data source.

#1 - Install A2K and create an .mde in A2K

#2 - the data source is in "Access 2000 MDB format"

Rich

Collapse -

by RichTee In reply to

Please note correction and clarification of first sentence: "You will not have a problem linking to, or importing from, the data source IF the following two statements are true."

Collapse -

by wordworker In reply to

Poster rated this answer.

Collapse -

by wordworker In reply to Get to Access 2000 data v ...

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Forums