Linking Excel to Access

**Ramification87** · 10-09-2010, 09:25 PM

Whenever i try to link more than one spreadsheet page to Access, an error message pop up. How do i solve this?

**Cheeky Charlie** · 10-10-2010, 05:45 PM

What's the error message(!?)

**Ramification87** · 10-10-2010, 07:21 PM

It'll say data has finished linking yet under my spreadsheet name, itll have PLANNING_ImportError. (see attached PROVtesting.zip). Ive tried thrice, same outcome each time.

I have few named ranges and they turn up fine but the main spreadsheet has got #Num!
which always seems to be the weekends I filtered out from it. (the previous doc is the spreadsheet)

Thanks in advance!

**Ramification87** · 10-10-2010, 07:26 PM

The data on that spreadsheet is reliant on the ranges, if that helps. Im guessing the inability to carry formula forward would be a problem root?

**alansidman** · 10-10-2010, 11:27 PM

It appears that the cells in your spreadsheet that Access is not importing and says contains errors are blank. The data type you specified in your linking of the tables is causing Access to think that something should be there when in fact the cells are empty. Because they are empty, Access is not creating records for them.

Alan

**Ramification87** · 10-11-2010, 01:48 AM

Hi Alan, thanks for ur response. But how do i overcome this issue? Any ideas/suggestions?

**alansidman** · 10-11-2010, 08:14 AM

Because your excel table is linked to Access and not imported, I was unable to see what the linked table actually shows in Access. See if this KB file helps you.

http://office.microsoft.com/en-us/ac...001219419.aspx

Alan