ProgramRasta
Member
- Local time
- Today, 08:18
- Joined
- Feb 27, 2020
- Messages
- 98
Hi All,
I hope everyone is keeping well!
I am trying to import an Excel file into Access. The trick being, I only need to import certain fields.
I have a spreadsheet named 'Data.xlsx'. It has data I need in the range D:F but I only need columns D and F.
Column D in my spreadsheet contains an identifier that may contain 100 rows - I only need a subset of this data that where the identifier is equal to the identifier in my database table 'Identifier'.
I was hoping to append this data into a table called 'Data' in my database.
Many Thanks for your time.
I hope everyone is keeping well!
I am trying to import an Excel file into Access. The trick being, I only need to import certain fields.
I have a spreadsheet named 'Data.xlsx'. It has data I need in the range D:F but I only need columns D and F.
Column D in my spreadsheet contains an identifier that may contain 100 rows - I only need a subset of this data that where the identifier is equal to the identifier in my database table 'Identifier'.
I was hoping to append this data into a table called 'Data' in my database.
Many Thanks for your time.