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 - 2002-05-06 : 08:58:57
|
| Meera writes "1)I have .dbf file which i convert into .txt file by using getstring property of ado. This text file then using bulk insert copy in the sql tables which is already created with the same mumber of fields and data type. When the data is varchar it is inserting sucessfully. When there is data type like float, or int it is giving me the an error 'type mismatch'. Can you please help me for this problem.2) I am writing to execute a stored procedure for bulk insert in an VB.6 application but it is not finding the procedure. But if i give sql statement then it works fine. Please give me the solution for it." |
|
|
|
|
|
Bulk insert from text file using sql server 7