Get Round Saved Import Bane Change

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
2,222
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi All

i have created a saved import which i use in code to run each day....

the problem i have is that 1 of the column names has changed...If i just change the column name in the table it comes with an error that search keyword not found...

How can i change the saved import column name easily?

if i re import it i have to change several of data types etc and its a ball ache - i just literally want to change the column header name and for it to work as normal

can you please advise the best way to get around this

im using access 2016 and on 365 if that helps

thank you
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
2,019
Office Version
  1. 365
Platform
  1. Windows
It's what I expected to find but wanted to check before saying you have to recreate but here it is

Notes:
  • You cannot edit other settings that are saved as part of the specification, such as the name of the worksheet or named range, data types of fields, and the source or destination table.
 

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,793
Office Version
  1. 2019
Platform
  1. Windows
^ It is also what I expected.
 

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
2,222
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
So i have to recreate :(

i would have thought there would be an option to change but thank you for confirming

so what is an easier way to do?

recreate
Change all types
Append to table

?
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
2,019
Office Version
  1. 365
Platform
  1. Windows
C) put the column name back to what it was?
or see post 4 here and maybe you can alter the system tables. I'd back up the db first in case it goes wrong.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,747
Messages
5,597,896
Members
414,186
Latest member
truebuddy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top