I currently run a spreadsheet which relies on access to produce queries from an external text file. The external text file hads recently been updated with two additional columns. Refreshing the linked table did not include the new columns. So I have deleted the table and recreated it.
This seemed to work, and the queries (To the best of my knowledge) run correctly in access. However my original spreasheet that connects to those queries returns a failed to access database.
Would this be expected?
Is their a way to add additional columns to my text file data and have that reflected in access, without recreating the table?