Access 2003 & SQL Server 2000

[Jim Richards]

I have just installed SQL Server 2000 on my PC (XP Pro w/SP2) and need to
upload (or something) to get the Access database into SQL Server. Any help
will be appreciated. Jim.

 

[Albert D. Kallal]

You don't mention if you been running a split database. (hopefully you have
been).

However, just go tools->database utilizes->upsizing wizard.

Another common approach is to use the tools (enterprise tools) that comes
with sql server, and it can import the data for you. So, just like access
can import dbaseII files, excel fiels, csv files etc, so can the tools
provided with sql server. Thus, you import the mdb data, and then simply
link your tables from ms-access to the database you created on the sql
server side.

 

[Jim Richards]

Thank you Sir. That did it. I now have one of my Access databases in SQL
Server. Have a good day. Jim.

 

[John W. Vinson]

I have just installed SQL Server 2000 on my PC (XP Pro w/SP2) and need to
upload (or something) to get the Access database into SQL Server. Any help
will be appreciated. Jim.

Just be aware that SQL/Server is *not* "Access on steroids". SQL/Server is
really more like JET, the database engine, than like Access; it doesn't (by
itself) include any forms, reporting mechanism, or much in the way of user
interface. It's very common to use an Access database as a "frontend" to data
stored in SQL.

John W. Vinson [MVP]