Still cannot import CSV files to SQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
crimmelcp
Forum Newbie
Posts: 16
Joined: Mon Jan 28, 2008 8:48 pm

Still cannot import CSV files to SQL

Post 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
Attachments
csvimport.jpg
csvimport.jpg (67.5 KiB) Viewed 104 times
crimmelcp
Forum Newbie
Posts: 16
Joined: Mon Jan 28, 2008 8:48 pm

Re: Still cannot import CSV files to SQL

Post 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
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Re: Still cannot import CSV files to SQL

Post by Luke »

Post Reply