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?