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-10 : 09:15:00
|
| Srinivasa ragavan writes "For import data from txt file to sql server 7.0, i am using BULK INSERt command in query analyzer.I am getting error.BULK INSERT table FROM 'C:\WINDOWS\Desktop\AA.txt' with (FIELDTERMINATOR = ';')ErrorServer: Msg 4801, Level 16, State 81, Line 1Bulk_main: The opentable system function on BULK INSERT table failed. Database ID 65, name 'table'." |
|
|
dsdeming
479 Posts |
Posted - 2002-05-10 : 09:17:00
|
| You need to supply a real table name to the BULK INSERT command, not the word table:BULK INSERT YourTableNameHere FROM 'C:\WINDOWS\Desktop\AA.txt' with (FIELDTERMINATOR = ';') |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-10 : 09:17:40
|
I hope that you didn't actually name your table "table". "Table" is a reserved word in SQL and should NEVER be used as an object name. Have you tried using another name for the table? I'd recommend trying that first, and see if it fixes the problem.There is a secion in Books Online on "reserved keywords", please review it to see if you have other object names that are in that list. If you do, you should rename them to avoid problems in the future.I've been SNIPED! AGAIN!  Edited by - robvolk on 05/10/2002 09:18:56 |
|
|
|
|
|
|
Error getting in Bulk Insert command