rename Excel columns and import

[qwertyjjj]

I have a spreadsheet that needs to be regularly imported into Access. Unfortunately some of the columns are called 1 - 10, 10 - 20, etc.

Access doesn't seem to like these because of the hypen -.
So, in the Access database I have named these columns 1To10, 10To20, etc.

Is there a way to either rename the Excel columns or map columns while importing into Access ?

 

[yummy7]

Try naming the column like [1-10] etc

 

[qwertyjjj]

The column in Access?

I just assumed that it would do that directly when importing the spreadsheet ?

I can't change the spreadsheet column directly unless through code.