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

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.

"MBAFMAX" wrote:

> 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

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];


"KARL DEWEY" wrote:

> 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.
>
> "MBAFMAX" wrote:
>
> > 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

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


"MBAFMAX" wrote:

> 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];
>
>
> "KARL DEWEY" wrote:
>
> > 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.
> >
> > "MBAFMAX" wrote:
> >
> > > 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

they are both "number"

"KARL DEWEY" wrote:

> Check and see if the Excel date of birth is date or text.
>
>
> "MBAFMAX" wrote:
>
> > 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];
> >
> >
> > "KARL DEWEY" wrote:
> >
> > > 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.
> > >
> > > "MBAFMAX" wrote:
> > >
> > > > 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

Access field needs to be DateTime datatype.

"MBAFMAX" wrote:

> they are both "number"
>
> "KARL DEWEY" wrote:
>
> > Check and see if the Excel date of birth is date or text.
> >
> >
> > "MBAFMAX" wrote:
> >
> > > 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];
> > >
> > >
> > > "KARL DEWEY" wrote:
> > >
> > > > 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.
> > > >
> > > > "MBAFMAX" wrote:
> > > >
> > > > > 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