Get data from MS Access database but not the primary Column

**aarona** · 08-31-2017, 01:23 AM

Hi All,

Will be needing your help again, so far I have a SQL query that will paste all data from MS Access.

However, I dont want the excel to include the Primary Key Column.

Is there a way to do this?

Thanks!

**Stormin'** · 08-31-2017, 03:59 AM

Create a query in Access that outputs the fields you want, and then create a connection to that query from Excel.

**aarona** · 08-31-2017, 04:08 AM

Hi Thanks.

But im already done with that part.

What I'm asking is, is there a better way of writing this code?

sQL = "SELECT [Col1], [Col2], [Col3], [Col4], and so on until Col89 FROM myDB"

The above statement is working however it's pretty long for a code.

Col0 = my primary key in ms access.

I'm wondering if it is possbile to be like this.

sQL = "SELECT * FROM myDB WHERE (EXCLUDING Pimary Key Column)"

So that's what I'm actually asking.

**Stormin'** · 08-31-2017, 04:51 AM

Hmm no it's not really possible, and that's by design because you should explicitly state the columns you want to return. You only have to build the string once. Alternatively you could just hide or delete the primary key column in Excel.