Linking dissimiliar tables

  • Thread starter Thread starter DustinS
  • Start date Start date
D

DustinS

I have a linked table from an SQLbase and another one from a Btreive
database. I am trying to port the info from one table to another in order to
synchronize the two datasets.

When I try to do an append query I get an error because the feild
definitions do not match, and since these are "linked" tables I can not
change the feild definitions. (all of the feilds in the Btreive data are
simply defined as "text" whereas the SQLbase data varies)

Is there any way to get around this?

Thank you!
 
While you can't change the field definitions, you should be able to apply
functions to convert from one data type to another in your query.
 
Create temp tables in Access and dump the data from Btrieve into it.
Then edit the types and append to SQL Server.
 
Back
Top