Access 2003 & SQL Server 2000

  • Thread starter Thread starter Jim Richards
  • Start date Start date
J

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.
 
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.
 
Thank you Sir. That did it. I now have one of my Access databases in SQL
Server. Have a good day. Jim.
 
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.
Click to expand...

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]
 
Back
Top