February 18, 2011 at 10:04 am
This might sound familiar to some of you and I suspect the answer is easy as well. I have a need to link an existing Access DB to an instance of SQL2008. This link is a "live" link, not a one-time upload.
The problem I have is the Table and Column naming used in Access. There are special characters and blanks used in the names. When I create the database link to SQL2008 (which triggers the duplication of the access DB) the names were preserved in the newly created SQL2008 DB. Now I'm having a world of trouble trying to access them via TSQL and Groovy/odbc.
Some examples are
table->Attachment 3
column->Equipment ID / System Number
Do any of you have some creative suggestions I can use to access these tables and columns from TSQL that does not require a change to the DB structure? I've found I can access the table name by putting brackets around it but the column names do not respond to this trick.
February 18, 2011 at 3:06 pm
I can answer my own post! I ended up leaving the table and column names as they were from Access. This preserves the Access layout. I created a new View on the SQL server that defined new table and column names for the ones imported from Access. Using this new view solves all my problems.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply