import data only from export file

[wsam]

I have an old full database export file with which I have to retrieve data from 3 tables. I cannot import into an existing database, I just want to be able to get the data into a spreadsheet to view. How do I do this? Thanks in advance.

 

[alexhu]

AFAIK you can't do it without importing the tables into a database.

Alex

 

[MikeLacey]

best bet (and I know you said you couldn't do it) would be to create a blank database and read just those three tables into it

next best - create a new user (schema) in your existing database and follow (carefully) the instructions for moving tables between users using exp and imp.

Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.