Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Flat File import...

Status
Not open for further replies.
awise

awise

IS-IT--Management
Dec 11, 2001
85
Hello,

I was wondering if there's a simple (or not so simple) way to write a SQL script that would take multiple log files, specifically the IISW3C log files, and import them into a SQL 2000 table (only one table) after they have been renamed as text files. I have a batch file that recopies the log files as text files already in place. Is this possible?

Thanks in advance,

Andrew
 
Sort by date Sort by votes
you'll probably get an answer faster if you asked on the microsoft sql server forum

--> Forum183


rudy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
207
carp
carp
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
247
carp
carp
sal21
  • Locked
  • Question
SORT by part of filed 2
Replies
5
Views
216
2009luca
2009luca
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
190
JarlH
JarlH
soushi01
  • Locked
  • Question
Nested For Loop update statement (pl/sql) 1
Replies
2
Views
166
soushi01
soushi01

Part and Inventory Search

Sponsor

Back
Top