copy records from excel to access table

[Guest]

Hi,, I have existing table (tblstudent) with fields called student ID, Names
and Address, i have an excel sheet with same info (Stident ID, Names and
Address) and Date of Birth... I have created the field "Date of Birth" in the
tblstudent, now how do i add the excel sheet data of "Date of Birth" to
"tblStudent" I have tried append and update querie ,,no luck.. so what am i
doing wrong??

Thanks so much.........m

 

[Guest]

Link the Excel by clicking on menu FILE - Get External Data - Link Tables.
Find your Excel and link.
In a select query left join tblstudent to the linked Excel spreadsheet on
the Student ID. Pull down the fields and run the query. Check the displayed
data - if it is ok then change query to Update query. Update the
[tblstudent].[Date of Birth] field with [YourLinkedExcel].[Date of Birth] and
run the query.

 

[Guest]

thanks so much,, but when i run the querie i got no data in date of birth
field.. her is what the SQL string looks like.. i named the link table
student1
UPDATE students INNER JOIN students1 ON students.[STUDENT ID] =
students1.[STUDENT ID] SET students.[date of birth] = [student1].[date of
birth];

Link the Excel by clicking on menu FILE - Get External Data - Link Tables.
Find your Excel and link.
In a select query left join tblstudent to the linked Excel spreadsheet on
the Student ID. Pull down the fields and run the query. Check the displayed
data - if it is ok then change query to Update query. Update the
[tblstudent].[Date of Birth] field with [YourLinkedExcel].[Date of Birth] and
run the query.

Hi,, I have existing table (tblstudent) with fields called student ID, Names
and Address, i have an excel sheet with same info (Stident ID, Names and
Address) and Date of Birth... I have created the field "Date of Birth" in the
tblstudent, now how do i add the excel sheet data of "Date of Birth" to
"tblStudent" I have tried append and update querie ,,no luck.. so what am i
doing wrong??

Thanks so much.........m

 

[Guest]

Check and see if the Excel date of birth is date or text.

thanks so much,, but when i run the querie i got no data in date of birth
field.. her is what the SQL string looks like.. i named the link table
student1
UPDATE students INNER JOIN students1 ON students.[STUDENT ID] =
students1.[STUDENT ID] SET students.[date of birth] = [student1].[date of
birth];

Link the Excel by clicking on menu FILE - Get External Data - Link Tables.
Find your Excel and link.
In a select query left join tblstudent to the linked Excel spreadsheet on
the Student ID. Pull down the fields and run the query. Check the displayed
data - if it is ok then change query to Update query. Update the
[tblstudent].[Date of Birth] field with [YourLinkedExcel].[Date of Birth] and
run the query.

Hi,, I have existing table (tblstudent) with fields called student ID, Names
and Address, i have an excel sheet with same info (Stident ID, Names and
Address) and Date of Birth... I have created the field "Date of Birth" in the
tblstudent, now how do i add the excel sheet data of "Date of Birth" to
"tblStudent" I have tried append and update querie ,,no luck.. so what am i
doing wrong??

Thanks so much.........m

 

[Guest]

they are both "number"

Check and see if the Excel date of birth is date or text.

thanks so much,, but when i run the querie i got no data in date of birth
field.. her is what the SQL string looks like.. i named the link table
student1
UPDATE students INNER JOIN students1 ON students.[STUDENT ID] =
students1.[STUDENT ID] SET students.[date of birth] = [student1].[date of
birth];

Link the Excel by clicking on menu FILE - Get External Data - Link Tables.
Find your Excel and link.
In a select query left join tblstudent to the linked Excel spreadsheet on
the Student ID. Pull down the fields and run the query. Check the displayed
data - if it is ok then change query to Update query. Update the
[tblstudent].[Date of Birth] field with [YourLinkedExcel].[Date of Birth] and
run the query.

:

Hi,, I have existing table (tblstudent) with fields called student ID, Names
and Address, i have an excel sheet with same info (Stident ID, Names and
Address) and Date of Birth... I have created the field "Date of Birth" in the
tblstudent, now how do i add the excel sheet data of "Date of Birth" to
"tblStudent" I have tried append and update querie ,,no luck.. so what am i
doing wrong??

Thanks so much.........m

 

[Guest]

Access field needs to be DateTime datatype.

they are both "number"

Check and see if the Excel date of birth is date or text.

thanks so much,, but when i run the querie i got no data in date of birth
field.. her is what the SQL string looks like.. i named the link table
student1
UPDATE students INNER JOIN students1 ON students.[STUDENT ID] =
students1.[STUDENT ID] SET students.[date of birth] = [student1].[date of
birth];


:

Link the Excel by clicking on menu FILE - Get External Data - Link Tables.
Find your Excel and link.
In a select query left join tblstudent to the linked Excel spreadsheet on
the Student ID. Pull down the fields and run the query. Check the displayed
data - if it is ok then change query to Update query. Update the
[tblstudent].[Date of Birth] field with [YourLinkedExcel].[Date of Birth] and
run the query.

:

Hi,, I have existing table (tblstudent) with fields called student ID, Names
and Address, i have an excel sheet with same info (Stident ID, Names and
Address) and Date of Birth... I have created the field "Date of Birth" in the
tblstudent, now how do i add the excel sheet data of "Date of Birth" to
"tblStudent" I have tried append and update querie ,,no luck.. so what am i
doing wrong??

Thanks so much.........m