Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting data from MS Access table columns based on column location instead of column names
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...- rashokku
- Post #2
- Forum: Microsoft: Access Other topics
-
Selecting data from MS Access table columns based on column location instead of column names
Let us I have a table name "Patient" in MS Access database 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...- rashokku
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
Updating values in a table based on the combination of values in the columns
First of all the thanks for your help. Attachment is the spec which I am explaining below. Columns in table: -------------------- MemberID (Primary Key): COL1 COL2 COL3 COL4 COL5 COL6 COL7 COL8 COL9 COL10 COL11 COL12 I have 13 columns in a table in MS Access database as above. I would like to...- rashokku
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
