Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel file sharing on a website

Sep 3, 2005 1:00PM PDT

I need to have 3 people sharing one Excel file as a master database of information. I have my own website, but how can I give them the ability to update the file the way that I can? I am new at website use, and a little better on Excel. Any ideas?

Discussion is locked

- Collapse -
I'm afraid you can't use Excel for that purpose.
Sep 3, 2005 8:39PM PDT

Use any server-based language supporting a server-based database. This is something for professionals at the moment.
Try the web design forum?

Kees

- Collapse -
I'm going to share the answer but will not...
Sep 3, 2005 10:18PM PDT

But I will not support you implementing it. Any word you don't understand I expect http://www.google.com to be sufficient for you to research. Sorry, but I only supply the parts. You perform the final assembly.

1. Install MySQL on some central server.
2. Create your table and set permissions as need be.
3. Instally MYODBC on your test machine and create the ODBC connection the the server.
4. Create the spreadsheet with the data sources on the MySQL server through the ODBC connection.

Viola, you've done it.

Bob

- Collapse -
Personally, I prefer ...
Sep 4, 2005 12:23AM PDT

4. Create an application with MS Access or Foxpro (or any ODBC-compatible databaseprogram you wish to use) with the data sources on the MySQL server through the ODBC connection.

But that's only the final touch. I see too much Excel around me where a more dedicated user-interface would be applicable. Might be a programmer's view, however. And I never used Excel on a ODBC-database, to be frank.

Kees

- Collapse -
I agree.
Sep 4, 2005 12:28AM PDT

I agree.

But when the customer specs it (and pays up) then we implement it with some notes that we are not responsible for data integrity, locking spreadsheets, etc. Spreadsheets are fine for spreadsheets, but not databases.

"I want a nice tuxedo with Scottish plaid tennis shoes."

Bob