Import *.Dat file in SQL Server 2005 Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Manish Mathur » Import *.Dat file in SQL Server 2005 Database...

Import *.Dat file in SQL Server 2005 Database

Rate Topic

Display Mode

Topic Options

Author

Message

yoothasak1

Posted Wednesday, April 08, 2009 2:40 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, March 31, 2011 8:10 PM
Points: 14, Visits: 55

Dear All,
I try to import the *.Dat file in to SQL database,
I have attachment a test.dat.
the text inside the file looks like:

How can I import the "time", "code", "type", and "target" into a table in Sql Database.

Please help,
Thank you.

Post Attachments

Test1.zip (8 views, 416 bytes)

Post #692844

jim-1129345

Posted Thursday, August 20, 2009 4:55 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 11, 2009 2:33 PM
Points: 8, Visits: 27

I have the same question. But I have seen anyone provides solutions yet. No one knows? Thanks, busyAnt.

Post #774679

jim-1129345

Posted Thursday, August 20, 2009 4:56 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 11, 2009 2:33 PM
Points: 8, Visits: 27

I have the same question. But I have NOT seen anyone provides solutions yet. No one knows? Thanks, busyAnt.

Post #774681

jim-1129345

Posted Thursday, August 20, 2009 6:11 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 11, 2009 2:33 PM
Points: 8, Visits: 27

bulk insert. worked now.

Post #774698

shalomb

Posted Tuesday, August 25, 2009 12:42 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:32 AM
Points: 46, Visits: 132

select from XML worerd is good :)

Post #776991

« Prev Topic | Next Topic »

Permissions