NetTalk Central

Author Topic: Upload files to SQL  (Read 2703 times)

Matthew

  • Full Member
  • ***
  • Posts: 137
    • View Profile
    • Email
Upload files to SQL
« on: April 03, 2011, 11:40:24 PM »
Hi

When I upload any file to my web server (specially *.xls), how can I put them into my SQL database and then download it from that database. I mean that I do not want to have this files physically on the disk, but only stored in database.

Could anyone help how to upload and download files to and from SQL database?

Regards,
Matthew

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11245
    • View Profile
Re: Upload files to SQL
« Reply #1 on: April 03, 2011, 11:43:42 PM »
When the file arrives it lands (by default) in the Uploads folder. You can have it land elsewhere if you prefer.

You would then need to write a process to read the data out that file, and put it into your SQL database. This isn "normal clarion" - not really related to NetTalk. Personally I'd used our Office Inside accessory to read the excel file (although this does mean Excel would need to be installed on the server).

Cheers
Bruce