I have a very simple database. Only two tables. The data is currently in .csv format and it looks as though it is only seperated by commas.
My web host (GoDaddy) offers a simple Windows server, with ASP. All I want to do is run a couple of simple queries using ASP.
GoDaddy allows me to create a MySQL DB from my hosting control panel. I did that. The version of MySQL is 5.0.
To run commands in MySQL, I have a hosting control panel function called phpMyAdmin 18.104.22.168.
I was able to create two tables that are exactly what I need. However, I have tried different methods-- inlcuding LOAD LOCAL-- to get the CSV data into the MySQL tables. I am absolutely stuck.
Bottom line: I have been trying for days to populate the MySQL tables with my CSV files and all I get are errors.
Is there not a simple way to do this?!? I thank you in advance!