469,088 Members | 1,273 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

Importing .txt to SQL

Has anyone any idea what could be causing this problem.
I've a large txt file, with each item on each row seperated with
quaotaion marks and seperated from each other by a comma.
I can import it no problem to Access, but when I try to import it to
SQL server, SQL Server gives me that "cannot find.... within first 8KB"
of data error.
Any ideas?
Ciarán

Jul 23 '05 #1
2 5114
http://www.plsgoogleit.com

?
<ch********@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Has anyone any idea what could be causing this problem.
I've a large txt file, with each item on each row seperated with
quaotaion marks and seperated from each other by a comma.
I can import it no problem to Access, but when I try to import it to
SQL server, SQL Server gives me that "cannot find.... within first 8KB"
of data error.
Any ideas?
Ciarán
Jul 23 '05 #2
(ch********@hotmail.com) writes:
Has anyone any idea what could be causing this problem.
I've a large txt file, with each item on each row seperated with
quaotaion marks and seperated from each other by a comma.
I can import it no problem to Access, but when I try to import it to
SQL server, SQL Server gives me that "cannot find.... within first 8KB"
of data error.


Have you tried adding those missing periods somewhere in the first
8KB of the file?

Joke aside, it is very difficult to help when you don't even care
to give the complete error message. It would also help if you gave a
sample of the file, and how you are trying to import it.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by qwweeeit | last post: by
4 posts views Thread by jean-marc | last post: by
11 posts views Thread by Grim Reaper | last post: by
7 posts views Thread by Darren | last post: by
5 posts views Thread by dixie | last post: by
7 posts views Thread by Timothy Shih | last post: by
reply views Thread by Mike Collins | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.