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
Still cannot import CSV files to SQL
Moderator: General Moderators
Still cannot import CSV files to SQL
- Attachments
-
- csvimport.jpg (67.5 KiB) Viewed 102 times
Re: Still cannot import CSV files to SQL
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
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