A way to import/export Data Only in tables?

P

Pat Dools

Hello,

We have a clinical research database that is used for data entry purposes
mostly and then shipped off for statistical analysis in SAS, and then shipped
back to me to verify that SAS did not change any data. I would like to
upload the DATA ONLY from the tables in the copy of the database shipped back
to me from my SAS stats person. I can see using 'File... Get External
Data...' or 'File... Export...' that I can get from my tables 1) Data and
definition or 2) Definition Only. But, is there a way I can get data only
from one copy of my database into another? All design elements
(tables/forms/macros, etc.) have exactly the same name in both copies of the
database.

Thanks.
 
G

Guest

hi
not sure exactly what you mean because i don't know how
you are "shipping it off" but there are a number of
options.
File Save As to an external db save as type....
you can choose text, excel, RTF, db5, foxpro, word and
others. you can also import from these sources.
 
G

George Nicholson

If you use File>GetExternalData>Import: Data & Definition and select your
tables you will end up with tblData (the production db table unchanged) and
tblData1 (what you just imported from the SAS db which you can now check for
changes against tblData).

In other words, when importing (or linking) a table, if the table name
already exists in the current db, Access will still import it but adds a 1
to the name. It will *not* overwrite data (but you might want to work from a
backup, anyhow). This should make it fairly easy to create queries that
will verify that Table and Table1 contain identical data, then, presumably,
delete Table1 (or its link).

Is that what you had in mind?

There are also various 3rd party tools which compare the data in 2 separate
files, below are 2 that I know of. I am sure there are others:
http://www.softwareaddins.com CompareDataWiz
www.fmsinc.com AccessDetective


HTH,
 
Top