Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DAT Files

Status
Not open for further replies.
Jun 29, 2001
195
US
Anyone ever seen anything like this. I'm trying to figure out a way to to convert. We received these files in *.DAT extensions. I'm wondering if this was exported from a UNIX based SQL db. TIA.


MSSQL SQL0014 plaid  013030427 D 9÷ ÿÿÿÿÿÿÿÿz$? {$? y$? ²}°²Mûl  ÿ 9  ÜH‘ ±tI K2ÿ 4:ÿæb x0Ü? ÕW  k
SQL001 sa  ED PRIME CASH AUTOMATIC PURCHASEMJLD135030278 …………|{{{xxxHHHHH@@@;74797954   f 6 JRNL×£p=
@D  ° 999906118 PURCHASE FR(1) CASH ACCT FEDERATED PRIME CASH SERIESMJLC135030279 š’’’’‰ˆˆˆ………LLLLLDDD;74797954 ° ‰F 6 DIVDš™™™™©P@D° ¯ 999906118 FEDERATED PRIH‘ .HI ˜ J ACCUMULATED EARNINGS POSTEDTDC151078537 ™‘‘‘‘ˆ‡‡‡………LLLLLDDD;74797954 ± JS 1 BINT y@D± ~ 169351AA1 ON 10000BIC152064842 h````WVVVTTTLLLLLDDD;74797954 ± KS 1 JRNL yÀD± £ $CASH SWEPT TO FEDERATED PRIME CASH AUTOMATIC PURCHASEMJLD152064843 …………|{{{xxxHHHHH@@@;74797954 ± LS 6 JRNL y@D± ° 999906118 PURCHASE FR(1) CASH ACCT FEDERATED PRIME CASH SERIESMJLC152064844 š’’’’‰ˆˆˆ………LLLLLDDD;74797954 ½ è—Æ 1 JRNL=
×£°BÕ@D½ Š $CASH SWEPT FROM MONEY MARKETMJLC164009960 tllllcbbb___HHHHH@@@;74797954 ½ é—Æ 1 WDRL=
×£°BÕÀD½ ‚ $CASH ACCOUNT BALANCEWDLD164009961 ldddd[ZZZ NSCC FULL TRANSFER DEL'D 016408388DDB08388000000œ™™–‘ŽŽ‰lldd\TLD;HHHHH@@@;’‰ˆˆˆ………LLLLLDDD;;;@@@;D;TLD;rd\TLD;D;;LD; Ϋ®}óC "sà  c    Ð(  ÿ          @  ÿ    0 0  ÿ  X  ÿ 8 8   @ @   H H   P P   Ø   ÿ  (   ÿ Ð 0!  ÿ  €)  ÿ x x   € €   ˆ ˆ       ÿ˜ ˜     
 ¨ ¨
 ° °
 ¸ ¸
 À À  È È  Ð Ð   ¨/ h1 Ï à à  è è
 ð ð
 ø ø    Ashley L Rickards
SQL DBA
 
I think I figured it out. These are 6.0 or 6.5 SQL databases. Does anyone know how to convert? Ashley L Rickards
SQL DBA
 
I think you will probably need SQL 6.x and then export the data and script out the table structure. I am not sure if there is a utility from MS -- doughtful.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top