arianna Posted June 11, 2006 Share Posted June 11, 2006 Hi;I have an excel sheet and want to send its content to mysql db. However not all the fields , just some selected ones. Any idea about how to connect the excel sheet and select specific fields?Thanks. Link to comment Share on other sites More sharing options...
justsomeguy Posted June 11, 2006 Share Posted June 11, 2006 You will probably want to export the Excel sheet as a CSV file, and then upload that to a PHP script. You can use the PHP to parse the CSV file. Here is some info on how to work with CSV files, make sure you read the comments on this page also, there is some useful information for you:http://www.php.net/fgetcsvYou can figure out which columns you are working with and skip the ones you want to. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now