Jump to content

Uploading a excel file into a database


Splurd

Recommended Posts

Well lets say you have a database, I use microsoft access, and you can select to import data from an excel file. And put the data from the excel file into the database in a table.was wondering if it was possible to make a script such that, when a person uploads a excel file, it will automaticly covert it and add the data from the excel file into the database.

Link to comment
Share on other sites

So you want to put the information in the spreadsheet inside the Access database. I've never looked into this, but I really doubt it will do that for you automatically, you will need to program it yourself. In order to read the Excel document at all, you might also need to buy a third-party component. You can read a plain-text CSV file just fine, but the XLS format is a binary format and Microsoft keeps it copyrighted, just like they do with all of their Office formats.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...