I have imported data from an excel spreadsheet which has created a table where I am missing column names or the column names are not correct.
I know how to change the column names and can manually insert columns by creating a 'select into' query. What I can't do is insert the new columns with a default value( when the query is currently run a text box appears requesting what the value should be). Is there a command that allows you to do this? I am trying to automate this as much as possible so that each query runs through a macro activated button.
Eg
macro 1 imports the data from several excel spreadsheets into 4 tables with the same table strucuture.
Macro 2 updates the newly created tables by either creating new tables in the correct table structure or updating the imported tables into the correct structure.
Eventually all the tables are combined into 1 which is then used for running queries against.
I know how to change the column names and can manually insert columns by creating a 'select into' query. What I can't do is insert the new columns with a default value( when the query is currently run a text box appears requesting what the value should be). Is there a command that allows you to do this? I am trying to automate this as much as possible so that each query runs through a macro activated button.
Eg
macro 1 imports the data from several excel spreadsheets into 4 tables with the same table strucuture.
Macro 2 updates the newly created tables by either creating new tables in the correct table structure or updating the imported tables into the correct structure.
Eventually all the tables are combined into 1 which is then used for running queries against.