convert dbse to sql

[apascual]

how to convert dbf file to sql table?
ex. i have tblcustomer.dbf & tblCust sql table. i want to insert all the data from tblcustomer.dbf to tblCust table.

pls help! thanks a lot.

 

[johnwm]

Assuming SQL2000 or better. Open up Enterprise manager, select your database, Right-click and pick All Tasks|Import Data. This takes you to the DTS wizard. Just do it from there if you want a one-time import, or you can save a VB version at the end of the wizard if you need to do it programmatically

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[apascual]

without using the Task\Import utility. i need to convert the
dbf file daily. is there an existing syntax for this?

 

[johnwm]

Yes, it's all done for you by the DTS wizard, including writing a complete commented VB module ready for your use. Run it once to generate the code, then include the module in your own app, calling it where needed.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'