Forum WebDev

I have this .dat file which I believe has the data for a sql database, but when I try to open it with sql server it just opens in notepad and its all gibberish. Any ideas?

I'm not 100% sure but have a read of this...

http://www.techtalkz.com/microsoft-sql- ... 6-5-a.html

It talks about upgrading the SQL version too.

you should be able to use LOAD.datA in file to map that format for import into mysql.

though you may have problems if the values are not delimited and spaces occur within the values as well as the delimiter.

Cheers, managed to get it sorted in the end. Mental note to self: Use MYSQL instead...

Can u please tell me how to use dat file in mysql.

Thanks.

I had to use it in an access database. You would need to convert the data from access to mysql. there are tools that do this you can buy or you could write a little php script to do it for you.