excel to acces

  • Thread starter Thread starter lee
  • Start date Start date
L

lee

hello

I am trying to import excel dates into access... excel dates are in
date and time format. but when i import into access, it is taking as
some text value and not as exact date.

Any idea on what should i do? please advise. thanks
 
hello

I am trying to import excel dates into access... excel dates are in
date and time format. but when i import into access, it is taking as
some text value and not as exact date.

Any idea on what should i do? please advise. thanks
Click to expand...

The problem is that Access has strong datatypes, and Excel doesn't: it may
look like a date to you but Access might not interpret it as one.

One possible solution would be to have an existing Access table with the
date/time field already defined; you could then *link* to the spreadsheet
(rather than importing it) and run an Append query to populate the table. It
might even be necessary to put a calculated field

CDate([excel-date-field])

in the Query. If this doesn't work, post samples of the data as it exists in
Excel.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
hello
Click to expand...
I am trying to import excel dates into access... excel dates are in
date and time format. but when i import into access, it is taking as
some text value and not as exact date.
Click to expand...
Any idea on  what should i do? please advise. thanks
Click to expand...

The problem is that Access has strong datatypes, and Excel doesn't: it may
look like a date to you but Access might not interpret it as one.

One possible solution would be to have an existing Access table with the
date/time field already defined; you could then *link* to the spreadsheet
(rather than importing it) and run an Append query to populate the table.It
might even be necessary to put a calculated field

CDate([excel-date-field])

in the Query. If this doesn't work, post samples of the data as it existsin
Excel.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com
Click to expand...

Hello John

This has been take n care of . Thanks. I am running a few queries on
tables linked to excel spreadsheet. The spreadsheets are 21 of them.
Is there a macro to run? Can you help me for few minutes today ASAP.
Thanks much
 
Back
Top