Hi,

Could anybody give any suggession of how i can export access database to sql server programmatically using VB including the indexes and default values

You can create a DTS package to transfer from access to SQL

Jaime E. Maccou

HI,

I am not sure if u want to perform thi task on daily basis or its a one time job.

Well If u go with DTS of sql server, u will get an option to save your DTS pacakage as Visaul basic Script. Choose that and sql will generate all the necessary code for you. U may have to do a little modification withing that code using VB IDE.

Gud luck

B. Anant