Q:
Change column names after concatenation
I have a set of data that I'm importing from a Microsoft Access database using the Microsoft Access Database Engine OLEDB provider.
This all works fine, but the database does not provide a standard column name. Instead, it provides something like 'Name', 'Title', 'First name', etc. This makes it difficult to use PowerPivot.
Is there a way I can modify the table's column names after concatenation?
Something like this
SELECT
TOP 100 PERCENT 'Name'
+''
+ 'Title'
+''
+ 'First name'
+''
+ 'Surname'
+''
+ 'Suffix'
+''
+ 'Country'
FROM mytable
A:
Although I cannot confirm this is the only way to do it, if you can specify the column names in the query, you can concatenate them yourself.
SELECT
'Name'
+''
+ 'Title'
+''
+ 'First name'
+''
+ 'Surname'
+''
+ 'Suffix'
+''
+ 'Country'
FROM mytable
Movistar Next Generation(TM) Smart TV Box With Magicremote
The MXNG box with Magicremote
The prototype of the Movistar Next Generation(TM) Smart TV Box with Magicremote has been built. It is the prototype of the Movistar Nuevointe(TM) smart box. Here we present the main features of the Movistar Next Generation(TM) Smart TV Box with Magicremote
More like this
Movistar Next Generation(TM) Smart TV Box
The movistar Nuevointe(TM) is the last box in Movistar ac619d1d87
Related links:
Comments