can't import .DAT file to SQL Server

Dear Expert,

I got data file AAA.DAT the size is around 800MB that can't import into my SQL Server 2000, coz it's too big i tried to open it with many applications but stil not work, please kindly help, this is exampale data inside;

SQL> Select *
2 from atb_txn
3 Where sales_date between 20060801 and 20060829 and substr(barcode_id,1,8) = '46295100' and exists(select 1 from bkk_store where atb_txn.store_id = bkk_store.store_id);
0001 2 1019089 20060809 55417 6001909
¢¹Á»Ñ§äÊéÁѹµèÍà¼×Í¡
5 1 5 .33 NM 4629510002592286 Y N
14-Aug-06

0001 2 1019089 20060809 55417 6000731
¢¹Á»Ñ§äÊé¶ÑèÇà¢ÕÂÇAP
5 1 5 .33 NM 4629510002592286 Y N
14-Aug-06

0001 2 1019089 20060809 55417 0500045
HOTCOF10 ¡Òá¿Ãé͹NESTLE
10 1 10 .65 NM 4629510002592286 Y N
14-Aug-06

0001 2 1019099 20060809 64902 3000064
¹Áá¾ÐÈÔÃÔªÑÂÃʨ״ 190CC.
18 1 18 0 NM 4629510005646048 Y N
14-Aug-06

Thanks in advance,
Chonlanet.

 

have you tried with bulk insert?

Here is some hints http://fox.wikis.com/wc.dll?Wiki~DataImport~SQL

 

Thanks kashem, i tried bulk insert as you recommended the url above but still can't import the data.

Is there any way else please advise.

Chonlanet.

 

I have not tried bulk insert, and I am not sure what are the wrongs there.

Here is an idea, check whether you can import them to ms access, if you can then from sql server import the mdb file.

Alternatively you can open the file from ms excel . save them and import the excel file from sql server

 

okay, i tried to open the file before with Excel (shown data as i pasted above, and limitation of itself can accept max 65k records per sheet), also ACCESS, both were can't. so i would appreciated if someone can advise on how to import it to SQL Server because of the file is too big.

Thanks
Chonlanet.

 

could you send the file to me? better upload to your server as zip file so that I can download it faster. you can mail to makctg[at]yahoo.com