W
Wutz
Hi there,
I have a list of students and grades in Excel to import into
Access2007; however, in the Excel file, the student names are text and
in the Access table tblGrades, the student name field is numeric
because it's actually linked to the autoassigned numeric primary key
StudentID in tblStudents. Is there some way to import the text names
without having to match and then manually change the student name to
their numeric ID first? I'll be importing several hundred records
every quarter and I'd rather not have to manually change the names
from text to their ID each time. I appreciate any help!
Thanks,
Wutz
I have a list of students and grades in Excel to import into
Access2007; however, in the Excel file, the student names are text and
in the Access table tblGrades, the student name field is numeric
because it's actually linked to the autoassigned numeric primary key
StudentID in tblStudents. Is there some way to import the text names
without having to match and then manually change the student name to
their numeric ID first? I'll be importing several hundred records
every quarter and I'd rather not have to manually change the names
from text to their ID each time. I appreciate any help!
Thanks,
Wutz