In Progress

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: use of data structure, tables in data structure, sql data conversion, new data structure, ms processing, may 11. 2008, got transferred, data structure that, data conversion sql, database processor, c map data structure, automatic data processing, accomplish business, about data structure, ms project help, ms access sql, how would you describe, ms access vba, get sql help, excellent in data, data transfer, Data tables, sql server 2008 access, data processing vba, access vba program

About the Employer:
( 0 reviews ) banhaa, Egypt

Project ID: #1274771

Awarded to:


Hello- I have several years experience executing scripts just as you describe in your posting. Please see PMB for a more detailed approach. Thanks, Dave

$225 USD in 2 days
(1 Review)

18 freelancers are bidding on average $197 for this job


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

$30 USD in 1 day
(61 Reviews)

I am an IT professional and I have done this kind of procedure several times with different instances. Please read PM.

$100 USD in 1 day
(3 Reviews)

Please consider my bid. Thanks, SG

$80 USD in 2 days
(6 Reviews)

Proposal for the processing rules, refer to the PMB

$200 USD in 2 days
(6 Reviews)

Hello, I would use VBA with a form that would report the transfer progress - number of records source/destination if fails error description for specific step and reimport option from any step. I have over 15 years o More

$200 USD in 5 days
(1 Review)

hello. I can do this for you. contact me thanks

$40 USD in 1 day
(0 Reviews)

I have very good knowledge in MS access and SQL server.

$75 USD in 2 days
(0 Reviews)

I have done work of data migration from vfp database to ms sql server.

$160 USD in 8 days
(0 Reviews)

I use scrip for this project. Pls. give me the project. I have last 6+ yrs. experience in development.

$150 USD in 3 days
(0 Reviews)

My last experience was a migration from SQL 2000 to SQL2005 with more than 200.000 [login to view URL] MSAccess + 10 years. Pedro Alves.

$200 USD in 2 days
(0 Reviews)

Dear Sir, I am PG in CS with 10+ exp in SW dev. Kindly refer to private message for more details as requested by you. Regards, RKP

$200 USD in 1 day
(0 Reviews)

I have done this type of project many times and should able to complete it same day. If there is a significant amount of problem data that won't transfer, I might need a day or two to get it over manually. Either way, More

$200 USD in 2 days
(0 Reviews)

I am a computer programmer since 2008, I have an experience about this, please see PMB

$150 USD in 2 days
(0 Reviews)

Hello there, Ready to start. Check PMB

$600 USD in 1 day
(0 Reviews)

experience will be shown in my work.i can work with you. plz check your PM.

$100 USD in 6 days
(0 Reviews)

************* Ready to start, have experience in data migration between MSACCESS and MSSQL, please check PM for more details *************

$400 USD in 5 days
(0 Reviews)

I am an expert on microsoft sql server and access. Since the discrepancy on data integrity and schema. A bid price is a bit higher. Please understand. Thanks!

$500 USD in 30 days
(0 Reviews)

dear, currently i am doing a job that involves a lot of ms-access data, vb apps(desktop)and sql. being more specifically i am doing a job where a big organization gets different types of Identity cards..doing same ..wh More

$90 USD in 3 days
(0 Reviews)