Hello I use to be on sql server 2005 (native client 9), now I'm using sql server 2008 (native client 10). The exporting a table to Access now takes 5 times as long to export. I can use sql manager 2005 to export the table, but that's a pain. Is there a way I can update the table to be more friendly exporting in sql 2008? What is the issue that might be causing this?
Sorry I don't know how to get the size in gigs out the table, but it's 878388 rows and about 20 colums. The export is usually arounf 2 gigs. I'm using the wizard at the moment. Later I plan on making a ssis package.