Import Access data whith varying columns

dbellavi · January 30th, 2008, 01:07 AM

Now the problem is how do i create the table in sql server with the same structure as the table in access.

urtrivedi · January 30th, 2008, 01:13 AM

sql server has option to import data, right click on database and some where you will fine import, follow the dialog box, select final.mdb, the process will import all tables with relevalant data types.

urt

dbellavi · January 30th, 2008, 01:15 AM

no can't use this method.
I need to automate this task. As this will be a weekly process that needs to be done.

urtrivedi · January 30th, 2008, 01:21 AM

In that case you need to create a vb or vb.net application which reads data from access and update sql server, also this application must to sheduled to run weekly.

urt

dbellavi · January 30th, 2008, 01:34 AM

Yes,

I want to write a DTS for this.

What i intend to do is,

first get the columns names of each tblTEST and write a create table sql and create a table and then import the data.

to do this do you know how we can get the column names in DTS may be by using activex script

urtrivedi · January 30th, 2008, 06:23 AM

Sorry I dont know about DTS with activx script.

urt