Access to MS SQL

  • Thread starter Thread starter Joe Rohn
  • Start date Start date
J

Joe Rohn

Hi Folks,

I have a fairly large Access database that I am going to convert to MS SQL.
I have done this before and it has always been a bit of an adventure! <g> I
am aware that it can be done directly through Access. My question is...do
any of you have any preferred methods of doing this? Any other software or
add-ons that you might know of for this purpose?

TIA

--
Joe

Microsoft MVP FrontPage

FrontPage Portal and Users Forums:
http://www.timeforweb.com/frontpage
 
Hi Joe,
I hear you. When it comes to importing data SQL Server is pickier than any
woman you'd ever meet :-) I'd suggest getting hold of any version of sql
server (the trial download or dev edition will do) and approaching the job
from the sql server end. Register your sql server through client network
utility then add it to enterprise manager. Create a new database with the
tables you need then right click on your database import data choose your
..mdb as a datasource then choose use a query to import data and bring the
data in one table at a time. There may well be a quicker to do the job but
this has always worked for me.
 
Back
Top