Prev: attachement data type vs. hyperlink
Next: "Package" error/label when embedding a BMP in OLE field
From: StuJol on 4 May 2010 14:22
Douglas, never used an update query before, can you please give me an example
of such a sql script?

"Douglas J. Steele" wrote:

> Import your table.
>
> Add a new date field to the table.
>
> Write an Update query to populate the new date field from the older text one
> using the CDate function.
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
>
> "StuJol" <StuJol(a)discussions.microsoft.com> wrote in message
> news:05F1CDE8-C301-4594-81E8-2A59CA3F233E(a)microsoft.com...
> > This is really fustrating as i managed to do it last week, unfortunalety i
> > didnt write down a procedure and cannot remember how i did it.
> >
> > i have a .txt file with approx 900,000 records exported from a 3rd party
> > system. i can import this into an access 2003 table without any errors.
> > what
> > i need to do is for the date/time field, change the format from text to
> > date.
> > unable to do this in access due to memory messages. i know i used excel,
> > think i exporting into excel, changed the colume format, then inserted
> > back
> > into access but when i tried doing it today excel cant import more then
> > 65,000 records.
> >
> > i know its possible, just cant remember how.
> >
> > can anyone help please???
>
>
> .
>
From: Daryl S on 4 May 2010 15:01
StuJol -
It will look like this, but use your actual table and field names:

UPDATE [yourTableName]
SET [yourNewDateFieldname] = CDate([yourTextDateFieldname]);

--
Daryl S


"StuJol" wrote:

> Douglas, never used an update query before, can you please give me an example
> of such a sql script?
>
> "Douglas J. Steele" wrote:
>
> > Import your table.
> >
> > Add a new date field to the table.
> >
> > Write an Update query to populate the new date field from the older text one
> > using the CDate function.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://www.AccessMVP.com/DJSteele
> > (no e-mails, please!)
> >
> > "StuJol" <StuJol(a)discussions.microsoft.com> wrote in message
> > news:05F1CDE8-C301-4594-81E8-2A59CA3F233E(a)microsoft.com...
> > > This is really fustrating as i managed to do it last week, unfortunalety i
> > > didnt write down a procedure and cannot remember how i did it.
> > >
> > > i have a .txt file with approx 900,000 records exported from a 3rd party
> > > system. i can import this into an access 2003 table without any errors.
> > > what
> > > i need to do is for the date/time field, change the format from text to
> > > date.
> > > unable to do this in access due to memory messages. i know i used excel,
> > > think i exporting into excel, changed the colume format, then inserted
> > > back
> > > into access but when i tried doing it today excel cant import more then
> > > 65,000 records.
> > >
> > > i know its possible, just cant remember how.
> > >
> > > can anyone help please???
> >
> >
> > .
> >
First  |  Prev  | 
Pages: 1 2
Prev: attachement data type vs. hyperlink
Next: "Package" error/label when embedding a BMP in OLE field