sql server express 2005
I have an access database that I'm using as place to append data into my sql server express tables(via linked).
I have a connection to a network sql server 2003 = Table1
connection to sqlserver express 2005 database = Table2
Through access I'm trying to append from table1 to table2...
both tables are sql server tables.
908,000 records...in Table1
I have succeeded in appending data with less records...with no problem.
Question : Is there something in sql server express2005 that I can tweak to succeed in appending large data.
I know I can use the dts wizard...
But doing it through access I can automate the process...
Any suggestions ?