Moving MS Access tables to SQLServer

[Guest]

I have an existing .MDB project. I want to move the tables to SQL Server.
How can I do that? Seems that the Get External Data / Link Tables assumes
that the DB already exists on SQL Server.

 

[Rick Brandt]

I have an existing .MDB project. I want to move the tables to SQL Server.
How can I do that? Seems that the Get External Data / Link Tables assumes
that the DB already exists on SQL Server.

If you think about it, you are not trying to "get external data" you are
trying to transform local data into external data. You either need to use
the upsize wizard or build the tables on the server yourself and then
populate them. I prefer the latter myself as I don't like many of the
assumptions that the wizard makes.

 

[Guest]

Yeah!
I moved them to SQLS with DTS. I was working against my local server. Super!
I then moved the DB to one of our remote servers in UK (I'm in Sweden). I
thought it would be possible just to reconfigure the data source externally
to point to UK. But NOT! I had to go through Access Link procedure. Then it
worked!
regards
FL