Selecting data table columns based on column location instead of column names

[rashokku]

I have a table name "Patient" in MS Access and the table has following columns.


Member_ID (First Column)
Member_Name (Second Column)
Member_DOB (Third Column)
Member_Address (Fourth Column)
Member Zip (Fifth Column)


I would like to select the columns based on the column location/number/sequence than the column name.

What is the syntax in SQL to locate the column location?


Thanks for your help.
Ram

[rashokku]

We have health plan data file that need to be imported in to MS Access table. The column header names keeping changing or not constant/fixed
but the column location/sequence/order is fixed. So, instead of selecting/reading the columns by column names/header names, I would like
to read the columns by column number/column locations and import it into exsiting table or drop existing table & create new table.


Please see the attachment for example.
Attachment 21078