May 15, 2017 at 4:22 am
I am using php to develop my website and I need to be able to browse for and upload an Excel sheet. I then need to store the information in an SQL database.
I realise this is an relatively open question but I am have looked for information on how to do this and have not got very far. Storing the data in the SQL database is fine but I am not sure how to upload the spreadsheet such that it can be read by the website.
If anyone can point me in the right direction I would be grateful.
Here my web page is: Birthday Wishes For Niece
May 15, 2017 at 4:34 am
Will the spreadsheet(s) always be in the same format? Personally I would suggest that you upload the file(s) to a specific place, and store the name of the file in a table. Then kick off an Agent task that runs an SSIS package to import the data for any files that are in table that are yet to be marked as imported (and mark them as imported).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 15, 2017 at 4:35 am
thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply