Error when Importing data

[pocquet]

Hi,

I am trying to import data from Excel into Access.

I hit the Excel button navigate to the file and click OK. The same error occurs when selecting link or import

The error reads:

"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opens only if the vba project is first deleted. Deleting the vba project removes all the code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA Project"

The excel file has no VBA projects Nor does the database I am importing into.

I have googled but couldn't find any solutions that are workable.

Any ideas?

Thanks

 

[Joe4]

The excel file has no <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> projects Nor does the database I am importing into.

What is the extension of the Excel file?

I have seen instances where there is no VBA code, but there is a residual empty VBA module out there that needs to be removed also.

 

[pocquet]

Hi,

Its an xlsx. totally raw file no editing etc. Will try to convert to CSV perhaps and see what happens

 

[pocquet]

Same error with CSV or text file

 

[Joe4]

A CSV would definitely not have any VBA code.
How exactly are you trying to import the file in Access?

 

[pocquet]

Via the data import wizard

So External Data ---> excel (or text file)

I thought it could be an add in issue so disabled all excel add ins but same error again.

I had 2013 but had to downgrade to 2010 (so I could use Bex Analyser through Excel 2010 as 2013 64bit isnt supported) so not sure if thats caused an issue.
However a colleague of mine has only ever had 2010 and has the same error.

Raised an incident with our IT team but I like to find a solution to speed them up...

 

[Joe4]

I have never encountered that before.
It definitely seems like an issue with the Access instance, whether and installation or add-in issue.
May want to try re-installing it and making sure you are current on all patches/updates.

 

[pocquet]

Hi,

Think I found a hotfix https://support.microsoft.com/en-us/kb/2581301

Will confirm this works for anyone in the future.

 

[Joe4]

Interesting...

Thanks for reporting this back to us, in case anyone else encounters the same issue.