Microsoft Access Update? Excel Import Wizard no longer rename invalid character to # or blank to NoName

[AegisAg]

Hi Guys,

First of all I am new here,

Here's the problem:

Why access no longer rename a blank column or has invalid character such as '.' into NoName or '#'. Is it because update? how to change the preference back to the old one? or maybe I can edit the registry to change it back?

I really confuse can't find any related matter around the internet.

Thank you!

*i have access 2016 Version 1707

 

[ranman256]

if you did an update , yes, this may have done it. Access gets 2 versions of applets and gets confused.
Usually, a repair/install fixes it,
or
and entire uninstall then reInstall has to be done BUT if you only have the old version and the update, youd be right back where you are.
so you may have to make workarounds.

 

[xenou]

I'm not aware of this feature ever being in access. You should give me details of the process and what you are doing so we can test it out (personally, I would simply not import data with blank columns or invalid column names - clean it up first, then import, so you have good and useful columns with proper names in your database).

 

[AegisAg]

Hi, I already did uninstall and re-install. Still the same.

 

[AegisAg]

Hi, So the story behind this, I usually import data from BW which has standard column which always contains first blank column and '.'. So instead I have to fix the column before upload it to access I prefer access choose the right name for me and so far causes no problem.

I notice this problem when I started to develop a new tools with access.

Update:

So recently I did some research, I build a random upload button and it works as I desired. So I came up with conclusion if you want the access to change the blank/contains invalid character into "NoName" or "#" use docmd.transferspreadhseet instead wizard.