Transfer data from MS Access97 dB into SQLServer dB

We have an old database in MS Access 97 containing data on customers of our business (names, addresses, purchases etc). We need to transfer this data to a new SQL Server 2008 database. Both the old and the new database have about 30-40 tables each.

The old and the new database are for the same purpose, but they have different structure. We cannot map the whole tables accross, instead the fields/columns of tables need to be individually mapped accross.

From this project we want to get an automatic conversion program:

1) we would help you map the fields/columns between the two databases,

2) you would create either a SQL Server Procedure, or a SQL Server Script, or a VBA macro in MS Access,

3) we would run this processor program,

4) you would manually fix any irregularities in the data to complete the data transfer.

All data must be transferred, no data can be left behind. Therefore, no matter how good your data transfer program is, you may have to fix manually any anomalies in data.

To get this project, you need to either show that you have done something very similar before, or that you have excellent knowledge of both MS Access and SQL Server.

Please describe in PM how you would accomplish this task: would you use VBA, SP or Script. Convince me that you got a good approach and you got this project.

This project must be completed by Friday 4 November.

Skills: Data Processing, Microsoft Access, SQL

See more: sql 2008, use of data structure, tables in data structure, sql data conversion, new data structure, ms processing, got transferred, data structure that, data conversion sql, database processor, c map data structure, automatic data processing, accomplish business, about data structure, access97, access transfer data, transfer access data sql server, ms project help, ms access sql, how would you describe, ms access vba, get sql help, excellent in data, data transfer, Data tables

About the Employer:
( 14 reviews ) Surry Hills, Australia

Project ID: #1266250

97 freelancers are bidding on average $171 for this job


HI, I have a tool for mapping fields from one table to fields of another table. Some mapping SQLs might need to be manually edited in case of mapping fields of more than one table to a single target table. Plz check More

$250 USD in 3 days
(43 Reviews)

I have done similar jobs few times before. Please see PMB for details.

$250 USD in 5 days
(76 Reviews)

I have 8 years experience in both access and SQL.

$90 USD in 4 days
(16 Reviews)

Dear Sir, I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last three years I involved many project in ETL, data warehousing, BI reporting and five years of application development experie More

$30 USD in 1 day
(29 Reviews)

I have few [url removed, login to view] see detail on PMB. Regards

$250 USD in 5 days
(4 Reviews)

I am old MS SQL programmer working with these databases over 10 years. I shall create project for Integration Services and you will be able to import data in place. I shall import data that you‘ll present me and shal More

$150 USD in 3 days
(3 Reviews)

Hi, I'm expert in database [url removed, login to view] check PMB for more details. regards

$90 USD in 3 days
(3 Reviews)

Hello I can do this for you. I have plenty of experience in both MS Access and SQL Server. Please see my private message for more details. Regards

$150 USD in 10 days
(10 Reviews)

Highly experienced .NET/MSSQL developer and software architect. I can write you code in C# and create a Windows app to transfer the data with row-by-row validation.

$150 USD in 3 days
(7 Reviews)

I am an IT professional and have experienced this kind of job. Please check PM.

$30 USD in 0 days
(3 Reviews)

Hello, Sir. I have many experiances of Access management using VBA and .NET office runtime as well as SQL server programming using .NET. I am going to do your work using .NET since .NET can enable me to read data More

$120 USD in 3 days
(3 Reviews)

Dear Sir, Please Read your PM. Thanks Meena

$100 USD in 1 day
(12 Reviews)

Hi,Kindly check your PM

$140 USD in 4 days
(4 Reviews)

Hello there, I have extensive experience with databases, but I'm sure you hear that all the time :) Check your PM I will try to paint a clearer picture. Cheers

$88 USD in 2 days
(2 Reviews)

Hi, I have good idea. Please check PM.

$75 USD in 2 days
(10 Reviews)

Please consider my bid. Thanks.

$100 USD in 2 days
(6 Reviews)

Hello, I am Sr. database engineer from China. Now I work on big software company in China. I did the similar solution for your requirement. I have done a DEMO script. Please check the PM. Thanks, hia8cn

$150 USD in 5 days
(1 Review)

Hello Sir I am ready to implement [url removed, login to view] Check you pmb for details Thankyou

$200 USD in 5 days
(2 Reviews)

Hi, an experienced MS SQL Server DBA (MCTS/MCITP SQL Server 2005), happy to help. Please check your PMB.

$250 USD in 5 days
(1 Review)

please see pmb. thanks.

$45 USD in 2 days
(1 Review)