sql2005 how to export data

yihui911

sql2005 How to export data to access

北帝浩然正气

express version does not support import and export functions
Only the enterprise and development versions are supported.
Right-click on the database and select "task" to import and export menu.

alcards

"D:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"

endymionzxt

1. Create a new access database

2.sql export to access

select *
into goods
from [ODBC;Driver={SQL Server};Server=.;Database=kpsj;Uid=sa;Pwd=123456].goods

endymionzxt

The above sql statement is executed in access,
The connection string and table name are modified according to the actual