OLEDB Connection with specific columns only

I have an OLEDB data connection and I am only wanting to import columns A:O into a table.

I can import all the data...successfully, but not limit it to just those columns (A:O)

I am populating the Connection Properties screen..

Thanks in advance...

Please Login or Register  to view this content.

Take a look at Data -> Other Data Sources -> MS-Query. When you connect to the data source you want, you can drag and drop just the columns you want in the order you want into the query builder grid. The interface is very similar to Access' query builder.