Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I map fields when connecting to SQL Server thru ODBC? 1

Status
Not open for further replies.

BallunarCrew

Programmer
Sep 3, 2006
58
US
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 done this lots of times and agree with your friend who suggests you either create a view on SQL Server or a query in Access.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top