Import Access -> sql server 2k5 express

[Crash893]

I'm looking around but i don't see an option to import.

I have a sinking feeling that express doesn't support this option



does anyone know a way to import

[brucevde]

SQL Server Integration Services (SSIS - formerly Data Transformation Services DTS) is not a feature of SQL Server 2005 Express Edition.

What exactly are you importing? Data only or Table structures as well? What about Queries/Views?

Is the Importing functionality needed in an application? Or are you just doing a one time convert of the Access database to a SQL Server database? If converting, later versions of Access have an Upsizing Wizard that might suit your needs.

[Crash893]

does access 2007 have a upsizeing wizard?


right now its the backend ( just data storage) for a access program ( all the forms are in a access database front end)

so im pretty sure its just tables and the data inside

[brucevde]

I know Access 2002 & 2003 both have the Upsizing Wizard. Its menu item is under the Tools -> Database Utilities menu.

[Crash893]

I think i foudn the area to upsize it in 2007

but now when ever i go to the wizard i get errors when i try to log into the local server


connection failed
sqlstate 01000
sql server error:2
Microsoft odbc Sql server driver shared memory connectionopen connected()). connection failed:
sql state 08001
sql server error 17
microsoft odbc sql server driver shared memory sql server does not exist or access denied