H
Hell-fire
Hi,
I know its most likely something I setup in access, but for the life of me,
I can't figure out what it is.
The problem is, when I import data from an excel file, instead of the data
going to row 2 in the data table, it jumps down to row 103. When I import
another excel file, the data is in row 205, it keep incrementing 102 rows.
The data being imported from excel is in column A to BL, Row 1 is the named
fields while row 2 is the data. The access table, the field names equal the
named fields from Excel. I do have an ID column with autonumber and set with
the primary key in the access table.
So if anyone out there that can point me in the right direction, I would
really appreciate it. It's probably something very simple, but
unfortunately, I'm very new to Access. Thank you
I know its most likely something I setup in access, but for the life of me,
I can't figure out what it is.
The problem is, when I import data from an excel file, instead of the data
going to row 2 in the data table, it jumps down to row 103. When I import
another excel file, the data is in row 205, it keep incrementing 102 rows.
The data being imported from excel is in column A to BL, Row 1 is the named
fields while row 2 is the data. The access table, the field names equal the
named fields from Excel. I do have an ID column with autonumber and set with
the primary key in the access table.
So if anyone out there that can point me in the right direction, I would
really appreciate it. It's probably something very simple, but
unfortunately, I'm very new to Access. Thank you