Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import *.Dat file in SQL Server 2005 Database Expand / Collapse
Author
Message
Posted Wednesday, April 8, 2009 2:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 (9 views, 416 bytes)
Post #692844
Posted Thursday, August 20, 2009 4:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, August 20, 2009 4:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, August 20, 2009 6:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 11, 2009 2:33 PM
Points: 8, Visits: 27
bulk insert. worked now.
Post #774698
Posted Tuesday, August 25, 2009 12:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 7:58 AM
Points: 46, Visits: 152
select from XML worerd is good :)


Post #776991
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse