Import/Export data only (1 Viewer)

D

DJN

Guest
I have data that resides in a Fourth Shift database. No problem in accessing the data. However, some of the fields in the Fourth Shift database are not the correct datatype, and so I cannot write queries to extract the data, and I cannot change any of the fields in the Fourth Shift DB. I need to export the data into Access tables. I can export to tables in Access, but the problem is that the primary keys and datatypes created in the Access tables are overwritten. I have tried the TransferDatabase method. Is there any way I can export the data only, thus preserving the structure of Access tables?
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 17:33
Joined
Feb 28, 2001
Messages
27,001
In the queries, you can change data types by using, e.g. CInt (to change something else to an integer), CLng (change to long), CStr (change to string), CSng (change to single), etc. Look up data conversions.

Also, if you know the other db's actual data type, you might be able to use the Format function in the query.
 
D

DJN

Guest
Thanks DocMan. Never even thought of that.
 

Users who are viewing this thread

Top Bottom