Saving spreadsheet in a database

  • Thread starter Thread starter Phil S
  • Start date Start date
P

Phil S

I'm an experienced C and Java developer, and a total newbie to Excel
MS office and VBA. We have a complex spreadsheet in use by many people
and the supervisor would like them to save their spreadsheets in a
database (Access??) elsewhere on the LAN so she can read them.

Can I use VBA to put a button on the spreadsheets to save them to an
Access DB on the LAN server? Do we need a SQL DB?

What is the best way to do this?
 
In Access, you could create a new database.
Then, choose File>Get External Data>Import
From the Files of Type dropdown, choose Microsoft Excel
Select one of the Excel files that she wants to read, and click Link.
Go through the steps in the Wizard to finish the import.
 
hi phil i think you want to save the binary file to the database sheets and
all
to do this in vb or dotnet i used the ado and the binary file
i dont know about java idea remains the same pick up the binary file and
stuff it into the db , to read recreate the file on the disk and use the
application that created it to open the file.
 
Back
Top