Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-23 : 07:56:56
|
| Madras Auto Service writes "Hi, I want to import data from dbase iii to SQL Server using VB 6.0 codes (without using DTS)" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-23 : 08:01:18
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24411If you absolutely can't use DTS, you can:1. Open the dBase III data with an ADO Recordset;2. Create a tab- or comma-delimited string of the data using the GetString method;3. Save the delimited string to a file;4. Use bcp or BULK INSERT to insert the data from that file into SQL Server. |
 |
|
|
|
|
|
Import dbase III to SQL Server using VB 6.0