Import a column from MDB to ADP

[Aliffi]

Hi , i have a ticky question

How can we import one cloumn with all its data from a MDB Table to an ADP table

regards

 

[petegoodman]

I don't know if this is what you want to do, but the easiest way is to simply selct the entire colum, and copy and paste it into another column.

Sorry if this is not what you want.

 

[payback]

An Access MDB will allow a connection to ADP data (actually you connect to the SQL table wherever it is held). Then you can use Access queries to update SQL tables.

This is especially handy because you can connect to the database where your MDB tables are and the SQL tables at the same time.