Anyone know how to import/export .mdb's in SQL 2005?
edit: I have discovered it myself!
1) Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB) at:
http://go.microsoft.com/fwlink/?LinkId=65111
being sure to select all the components
2) Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"
This wizard enables you to important/export different file formats such as .xls (MSExcel) and .mdb (MS ccess) into SQL Server 2005 Express. I find it easier to edit using Access cos of simple things like the 'find'/search function etc.
edit: I have discovered it myself!
1) Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB) at:
http://go.microsoft.com/fwlink/?LinkId=65111
being sure to select all the components
2) Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"
This wizard enables you to important/export different file formats such as .xls (MSExcel) and .mdb (MS ccess) into SQL Server 2005 Express. I find it easier to edit using Access cos of simple things like the 'find'/search function etc.
Last edited: