Access to MS SQL

[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

 

[Jon Spivey]

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.

 

[Joe Rohn]

Hi Jon,

Sound advice and thanks for it! That is exactly the route I will take!

I have no experience with the following..however a couple developers told me
that they find it to be very useful:

http://www.aquafold.com/

I may also add that to my list of toys to play with

--
Joe

Microsoft MVP FrontPage

FrontPage Portal and Users Forums:
http://www.timeforweb.com/frontpage