Access data into SQl

[ThomH]

Were converting a large Access database to SQL. There are over 100 tables and queries. Were trying to find a faster way to update the data from Access to SQL, instead of appending each table as we are doing now, which takes a long time.
Thank you

 

[dbomrrsm]

Look at DTS - import export wizard - you can import all the tables in one go.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[ThomH]

Thank you. Tried this, but process got hung up and would not complete. Any hints on the best way to accomplish this would be greatly appreciated.

 

[dbomrrsm]

Getting hung isnt really to do with programming more to do with being naughty !!!

Only joking - its network or similar probs that are causing this not dts.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]