BallunarCrew
Programmer
I have an Access db (32 bit version 16) that I have set up an ODBC link to SQL server tables on Azure. Some of the field names do not match up.
I have a friend that is an Access expert and whom I trust that is telling me the only way to do this is to create either a SQL server view or an Access query with column aliases. I believe this to be true as when I have gone through the wizard to set up the ODBC link, there is no place to map the fields.
My boss has been told by someone else, who supposedly connects Access databases to SQL server all the time, that there is a screen where you can map the fields like we can when exporting contacts from Outlook to an iPhone. I have seen that export screen and it is similar to the screen when we create an Append query - you can say the LName field goes into the LastName field, etc.
Does this mapping function even exist when creating a link to SQL server? Is there maybe a third party tool that does this? Trying to settle a debate and maybe learn something new if it is there to learn.
Thanks!
I have a friend that is an Access expert and whom I trust that is telling me the only way to do this is to create either a SQL server view or an Access query with column aliases. I believe this to be true as when I have gone through the wizard to set up the ODBC link, there is no place to map the fields.
My boss has been told by someone else, who supposedly connects Access databases to SQL server all the time, that there is a screen where you can map the fields like we can when exporting contacts from Outlook to an iPhone. I have seen that export screen and it is similar to the screen when we create an Append query - you can say the LName field goes into the LastName field, etc.
Does this mapping function even exist when creating a link to SQL server? Is there maybe a third party tool that does this? Trying to settle a debate and maybe learn something new if it is there to learn.
Thanks!