Re-Log Access Data Into SQL

PassRusher · 2012-10-16T11:54:53.000Z

We are using an internet monitoring program that used a simple Access DB but I moved the program over to SQL. The company said I can re-logging the Access data into SQL but not sure exactly what that means in comparison to a simple import. I tried an import and it failed and there was no way around the failure.

I did a search and didn’t find much about “re-logging” access into SQL. Any tips?

Thanks!
Brian

glen · 2012-10-16T12:12:43.000Z

Never heard of re-logging in that context… I would have thought an import was the way to go to get your historic data in.

PassRusher · 2012-10-16T12:37:50.000Z

Yeah…the import kept failing multiple errors…we may be OK with no import because the reason we moved to SQL is that the Access DB stopped collecting data last week and we couldn’t figure out why and their support, while free, is lousy…we are within our 30 days so may look for another monitor but this one is good.

glen · 2012-10-16T12:58:04.000Z

How were you importing? What were the errors?

I’m assuming you have created the SQL table(s) with the same data types as the Access MDB, it should be pretty straight forward using Integration Services, set your connection, map your fields and go…OK you might have to hit next a few times along the way

You may already know/have done this, if so I’m sorry, I’m not trying to teach you to suck eggs!

To Just try and pull the data out you could create a blank DB in SQL Server Management Studio;

Right click and choose import

Select a data source (Access!)

Select the MDB

Copy data (copies everything) or you can write a query to narrow the import

Run or save package…

PassRusher · 2012-10-16T13:09:23.000Z

Thanks Glen…I’ll give it a shot when I can. Management is starting to be OK with not importing but will try if they still want to get it.

glen · 2012-10-16T13:30:10.000Z

No worries, good luck!

PS I think it’s right click → All Tasks → Import

Alternatively post your errors here, I may or may not be able to help but I’ll try.

PassRusher · 2012-10-16T13:37:26.000Z

Thanks again…will give it a shot if I can…right now, about to pre-order (in 30 minutes) a Surface for our owner (with hopes he will get me one too!)

gerard-treacy · 2012-10-17T07:01:54.000Z

Did you try the Upsizing Wizard in Access? It converts data types to the corresponding SQL types and uploads the data. It usually works very well for data tables, not so good with queries but I don’t think you need that.