RWilliams500
New member
- Local time
- Today, 06:31
- Joined
- May 22, 2024
- Messages
- 6
So I have a spreadsheet that's exported from another system. I would love to create a system that lets someone upload the spreadsheet and it pulls the data into an existing table.
What I'm imagining is some code, VBA or SQL, equating the spreadsheet column name to the table name. Then just importing to the proper spots based on that equating.
I've never worked on something like this before, so before diving in I just wanted to see if it was possible without being a huge headache. Easy, difficult, or not even possible?
What I'm imagining is some code, VBA or SQL, equating the spreadsheet column name to the table name. Then just importing to the proper spots based on that equating.
I've never worked on something like this before, so before diving in I just wanted to see if it was possible without being a huge headache. Easy, difficult, or not even possible?