addin excel file to database

rakennedy75

Here is what I am doing.. I am using a third party that automates a script to a folder on my server. From here I have a MySql statement that I load through phpMyAdmin into my corresponding databases. This is the tails end of my code...

// tab delimited code
load data infile 'textPath/textfile.txt' into table myTableName

// comma separated
load data infile 'textPath/textfile.txt' into table myTableName FIELDS TERMINATED BY ',' ENCLOSED BY '\"';

and now I would like to know if I can add an excel file the same way. I am sure there is something extra that tells the database to recognize this as an excel file. Any ideas on how to do this would be helpful.

rachel2004

From within Excel, do a "SAVE AS" save it as a CSV (comma delimted) file. If you want tab-delimited, select that one when you do SAVE AS. You can't use Excel in it's native format (.xls) as you know.

rakennedy75

Thats what I was afraid of, haveing to change it on my end defeats the purpose, i needed to automate this. Thanks for the help.

mw-dnb

you could setup a web service for this with some freely available MS C++ interpreters. i believe the MFC library comes with them.

could take a lot of work, but if you need it you need it.

i personally would use CSV as its a common file type.

rakennedy75

I agree with the csv, going to talk to the other party involved and see if they have an alternative way of exporting their data. I find it hard to believe that their utility can't export out as csv or tab delimited but does export out as excel. Thanks for the suggestion.

mw-dnb

Originally posted by rakennedy75
I agree with the csv, going to talk to the other party involved and see if they have an alternative way of exporting their data. I find it hard to believe that their utility can't export out as csv or tab delimited but does export out as excel. Thanks for the suggestion.

if it was made by a visual basic programmer don't be surprised - HAHA!

what is a CSV - i only know a .net?

😛