Page 1 of 1

Still cannot import CSV files to SQL

Posted: Fri Feb 15, 2008 2:37 pm
by crimmelcp
To All:
I still cannot upload a csv text file to SQL table.
I have been trying to use CSVImport that I found on some of the boards.

Do I have a setting wrong.(see attached jpg)
I should be able to select the column to be imported.
All that I get are the words select and None

Has anyone else used this application
Do I have a setting wrong

Re: Still cannot import CSV files to SQL

Posted: Fri Feb 15, 2008 3:13 pm
by crimmelcp
What my goal is:
I have vendor table with the following fields

IDVendor
Vendor_Number
Vendor_Name
Address1
Address2
Vendor_City
Vendor_State
Vendor_Zip
Vendor_Country
Vendor_Phone
Vendor_Fax
Vendor_Contact
Vendor_Email

I want to put a button or a link on a form to import new vendor information.
(users with admin rights only would see this form)
The user would click the button.
The PHP script would check to see if a file exists called vendupld.csv(or txt or what ever is the correct file type)
If no file, a message would show that there is no file to import.
If there is a file called vendupld.csv, then the script would read the records in the csv file
And append(import) this data (unique vendor_Numbers only) to the Vendor table.


Can This be Done?????
Thanks
Charlie Crimmel

Re: Still cannot import CSV files to SQL

Posted: Fri Feb 15, 2008 3:24 pm
by Luke