getting dat files uploaded and.

[KG2RG]

Hi, I am very new to SQL. My servers runs phpMyAdmin.

I created a database, and a user.

I also created a few tables, and fields. I have several huge dat files and I wanna get them uploaded to the server.

I asked my server provider, and they said I may need to convert my dat files into SQL file formats. Is this true, and haw do I do it.

Here is what 1 of my dat file looks like, only this is just a snall prtion:

AM¦226081¦¦¦AE4XH¦E¦A¦4¦¦¦¦¦¦¦¦¦A¦
AM¦226603¦¦¦AF4KW¦E¦A¦4¦¦¦¦¦¦¦¦¦A¦
AM¦235651¦¦¦K1UAX¦A¦C¦1¦¦¦¦¦¦¦¦¦¦
AM¦237666¦¦¦K2ITV¦T¦C¦2¦¦¦¦¦¦¦¦¦P¦
AM¦238501¦¦¦K2OKW¦G¦C¦2¦¦¦¦¦¦¦¦¦¦
AM¦239974¦¦¦K2ZXO¦A¦C¦2¦¦¦¦¦¦¦¦¦¦
AM¦241335¦¦¦K3JIZ¦G¦C¦3¦¦¦¦¦¦¦¦¦¦
AM¦243996¦¦¦K4BHI¦T¦C¦8¦¦¦¦¦¦¦¦¦P¦
AM¦246946¦¦¦K4KQ¦E¦A¦4¦¦¦¦¦¦¦¦¦¦
AM¦247083¦¦¦K4KZS¦E¦C¦4¦¦¦¦¦¦¦¦¦A¦
AM¦249372¦¦¦K4VIR¦G¦C¦5¦¦¦¦¦¦¦¦¦¦
AM¦252609¦¦¦K5MSW¦G¦C¦5¦¦¦¦¦¦E¦¦¦P¦
AM¦256709¦¦¦K6LGU¦A¦C¦6¦¦¦¦¦¦¦¦¦¦
AM¦257380¦¦¦K6PGL¦G¦C¦6¦¦¦¦¦¦¦¦¦¦
AM¦257977¦¦¦K6SDJ¦G¦C¦7¦¦¦¦¦¦¦¦¦¦
AM¦258070¦¦¦K6SMR¦¦¦6¦KN6LA¦¦¦¦¦¦¦KF6LLR¦¦KREIDER III, GEORGE W
AM¦260898¦¦¦K7LOB¦G¦C¦7¦¦¦¦¦¦¦¦¦¦
AM¦262963¦¦¦K7ZOX¦E¦C¦7¦¦¦¦¦¦¦¦¦A¦
AM¦266353¦¦¦K8UFX¦G¦C¦8¦¦¦¦¦¦¦¦¦¦
AM¦272129¦¦¦KA0FZR¦N¦D¦10¦¦¦¦¦¦¦¦¦¦
AM¦275438¦¦¦KA0VVN¦N¦D¦10¦¦¦¦¦¦¦¦¦¦
AM¦275661¦¦¦KA0WRS¦G¦D¦4¦¦¦¦¦¦¦¦¦N¦

[KG2RG]

?

[maccas]

Try and do a seach and replace. Download textpad and do a regular expression replace (search > replace and check regular expression), find ^ and replace it with INSERT INTO `your_table_name` VALUES (' the do another regular expression and replace $ with ');

Then uncheck regular expression and replace all the ¦ with ',' backup first and give it a shot.