Timeseries of tables in Access

Question

I would like to store a table for each day containing spatial data (x,y,value) where I can easily pick a value from a specific date and cell (x,y) from the database to a excel spreadsheet. How to do write this table from excel to access and from access into excel and how the db should look like....that is my question

Answer 1

Hello,

Connections would be one-way. You could import a linked table from Excel to Access or you could import Access table to Excel. You could use Office feature or use ADO connection to link them.

For more information, please visit

Import or link to data in an Excel workbook 

Connect to (Import) external data 

Office Space: Tips and Tricks for Scripting Microsoft Office Applications

How To  Open ADO Connection and Recordset Objects

Regards,

Celeste

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].