ETL tool: transform database made in Access

[Medha Arya]

I am making an ETL tool. I am not getting how to go about the transformation in the database made in Access. Can you please help me with the code?

[Seth Schrock]

What exactly is an ETL tool? Also, we don't just write code for you. What we can do is help you with your code. So we would need to see what you have and what error messages you are getting or the results that aren't what you want. Please read before posting (VBA or SQL) Code.

[mshmyob]

An ETL (Extract Transform Load) tool is an application like SQL Server Integration Services (SSIS). But as Seth points out you need to show us where you are having the problem. I don't think anybody here is going to attempt to write a generic ETL tool that can accommodate all possible scenarios or functionality of a tool like SSIS.

cheers,

[Rabbit]

ETL is an acronym for Extract, Transform, Load. Basically taking data from one location and then transforming it to match a target location to load into.

How you need to transform the data depends on the source design and the target design. You have given us neither so we can't really help any.

[Medha Arya]

I have made the databases in access and sql and the main database is in sql. I m not getting how to convert the data stored in access to extract and then store it in sql

[Rabbit]

There's really no need to... Access can directly link to a table in another DBMS.

[zmbd]

Rabbit, I think Medha want's to go from Access to SQL Server.

Medha, which version of Access are you using