I'm trying to create a new Access 2003 database with some data from an Excel spreadsheet. The thing is that Excel file is constantly updated, so I need some solution to keep the Access database and the spreadsheet in sync at all times. Or at least have a manual "update" button, like in Excel.
Another thing is that the xls file is on a remote computer in an intranet. I tried importing from Access (going to My network places\Folder\file.xls), but it says that the wizard is unable to import, make sure the file exists, bla bla. This also happens if I select the other option, link tables.
Is Access unable to import from another IP? Only local files? :unsure:
P.S. I forgot to add, don't think it matters, but the Excel file is read-only.
Question
TDT
Hi guys,
I'm trying to create a new Access 2003 database with some data from an Excel spreadsheet. The thing is that Excel file is constantly updated, so I need some solution to keep the Access database and the spreadsheet in sync at all times. Or at least have a manual "update" button, like in Excel.
Another thing is that the xls file is on a remote computer in an intranet. I tried importing from Access (going to My network places\Folder\file.xls), but it says that the wizard is unable to import, make sure the file exists, bla bla. This also happens if I select the other option, link tables.
Is Access unable to import from another IP? Only local files? :unsure:
P.S. I forgot to add, don't think it matters, but the Excel file is read-only.
Link to comment
Share on other sites
0 answers to this question
Recommended Posts