Jump to content

Insert data from a textfile into table


Mregina

Recommended Posts

hey all.

i'm having a problem here. i'm trying to upload a table into the database. i've tried .csv, excel, .txt, word... and none work. if i select DATA as my upload method i get the following error:
#1045 - Access denied for user: 'clearpo_master@localhost' (Using password: YES)

and if i use DATA LOCAL i get:
#1148 - The used command is not allowed with this MySQL version

so im confused. ive tried it every which way except the right way apparently. im running phpMyAdmin 2.5.3 with MySQL 4.0.24.

if anyone could give me a tip, i'd appreciate it.
Link to comment
Share on other sites

Sure, it is very simple data:

I tried saving it as .sql and upload it..same results. The column headers are exactly the same as the database headers...same results:

prodnum size cup style color status discontinued
0200000000 0 0 0 0 0 0
0207000000 0 0 0 0 0 0
0218000000 0 0 0 0 B/O 0
0218003200 32 0 0 White B/O 1
0218003400 34 0 0 White 0 0
0218003600 36 0 0 White 0 0
0218003800 38 0 0 White 0 0
0218004000 40 0 0 White 0 0
0218004200 42 0 0 White 0 0
0218004400 44 0 0 White 0 0
0218004600 46 0 0 White 0 0
0218004800 48 0 0 White 0 0
0218013200 32 0 0 Black B/O 1
0218013400 34 0 0 Black 0 0
0218013600 36 0 0 Black 0 0
0218013800 38 0 0 Black 0 0
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.