|
Hi, is this possible at all? From my understanding there are tools you can
buy to convert and merge data from an excel / csv document into an MSSQL
table, the thing is the convertor needs to be run on the server side and has
direct connection to MSSQL. What I need to do though, is to import an excel
/ csv file into an MSSQL table hopefully remotely via PHP. So is there a way
to do this at all?
I know PHP has file functionality to load the file's contents into a string,
so in theory we can write some PHP code to take a URL and analyse the csv
file and then manipulate the data and import into the MSSQL db, do you know
any sample code that does this? And am I right in thinking that this is
doable?
Thanks,
Jules
| 
