Online Excel Database

Im looking for a solution which i need to achieve using excel.
Im creating a VBA application using excel.
I need all the data on the excel sheet to be stored online in some table/database.
This would enable me to use the same excel sheet on multiple systems at the same time and having up to date information on all the systems.
Please let me know whether such a thing is possible.
Also let me know the various options available.

You may consider saving the data as a CSV file to a shared drive. The following is code to read and write CSV Files. However, I recommend using MS-Query to read the data from the CSV file. It will bring it in as a table. Also it will preserve the data type. Sometimes when you import a big string that looks like a number, Excel converts it to scientific notation which is not what you generally want.

Please Login or Register  to view this content.

I'll put in a plug for Excel files here. Excel files know how big they are so you always know what the copy range is.

Here is a pointer to how to work with Excel files: http://www.excelforum.com/excel-prog...-database.html.

Here is code on how to clear an Excel file. The syntax is ClearTable SheetName, TableName

Please Login or Register  to view this content.