Import Data from SQL View in different Columns

[wrathyimp]

How can i import data with headers from a sql view, while having the first 3 columns and rest columns separated by blank column.

 

[Norie]

You could Data > Get External data... and use SQL to return all the columns in the view and a blank column.

Or do that twice and import the first group of columns and then the second group with a blank column between.

 

[wrathyimp]

Thanks Norie,

But your second option seems fine, but who can i define columns in my data pull?

 

[Norie]

You would need to do that with MS Query or SQL.

 

[wrathyimp]

Norie can you elaborate on this, as SQL is new to me.

 

[Norie]

Have you tried Data>Get External data...?

That should be the starting point and you might be able to do this using MS Query.