Importing Data from a Snapshot File

[Peter Hallett]

Is there a way of importing data from a snapshot (.snp) file into an Access
table? For security reasons, the originating database is not available, nor
is it likely that the database owner can be persuaded to send the data in any
another format.

(I notice another contributor has raised a very similar query in respect of
SAP files. I don't recognize this file type but I assume it has nothing to
do with SNP files because I cannot see any way of getting the data from the
latter into .TXT format.)

 

[Klatuu]

An snp file is a graphical representation of data and cannot be parsed out.
You will have to convince them to give you another format. I would recommend
you ask for a csv file.

 

[Stephen Lebans]

The best you can do is use the Text Only Windows Printer driver, and output
the Snapshot, via the Snapshot Viewer application, to a text file. This is
no the same as a formatted text file, ie. csv, but with a bit of
manipulation manually or programmatically, you will be able to access the
data behind the Snapshot file..

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.