I am trying to import some data from an excel 2007 worksheet into an access 2007 using the import feature of access 2007. I am tyring to use the column headers in the excel workhseet. However I am getting the following message:
The first row contains some data that can't be used for valid Access field names. In these cases, the wizard will automatically assign valid field names.
Thus can you point me to a reference that shows what are invalid characters for access 2007? This way I can delete the invalid characters.
The first row contains some data that can't be used for valid Access field names. In these cases, the wizard will automatically assign valid field names.
Thus can you point me to a reference that shows what are invalid characters for access 2007? This way I can delete the invalid characters.
