Import *.Dat file in SQL Server 2005 Database

  • 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.

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

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

  • bulk insert. worked now.

  • select from XML worerd is good 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply