EzGoingKev
Registered User.
- Local time
- Yesterday, 21:34
- Joined
- Nov 8, 2019
- Messages
- 185
Good morning.
I receive an Excel file from another department in my company. I cannot have the field names changed - it is what it is.
The Excel file has data from A to G.
Row 1 has the effective date so it will have "Effective July 1st 2024" in Column G.
Row 2 has the field names. Two of the fields have periods at the end of them:
- Customer Part No.
- MPA Part No.
My table does not have the periods in them as you cannot use the periods in field names in Access.
If I manually go in and remove the periods from the two field names this works 100%:
Is there something I can do so I do not have to go into the file manually and remove the periods?
I receive an Excel file from another department in my company. I cannot have the field names changed - it is what it is.
The Excel file has data from A to G.
Row 1 has the effective date so it will have "Effective July 1st 2024" in Column G.
Row 2 has the field names. Two of the fields have periods at the end of them:
- Customer Part No.
- MPA Part No.
My table does not have the periods in them as you cannot use the periods in field names in Access.
If I manually go in and remove the periods from the two field names this works 100%:
Code:
DoCmd.TransferSpreadsheet acImport, 10, "table_name", strPath, True, Range:="excel_sheet_name!A2:G5000"
Is there something I can do so I do not have to go into the file manually and remove the periods?