• 0

Excel to Access


Question

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

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.