Importing Data from a Snapshot File

P

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.)
 
K

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Suppress display when outputting to a Snapshot file 1
Importing a 'non-standard' file type 2
Importing a file from another database 2
Snapshot from data access page 0
Importing data from SAP 1
Save each page as a seperate Snapshot file when Exporting to Snapshot Format 0
Make a Snapshot File from an Excel Worksheet 0

Top