Recognizing data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

george - 05 Mar 2008 07:40 GMT

The problem is next I'm imoprting data from a database and this imported
data consists os from a date_time and value. the problem is next, the time
and date field isn't recognized as such and bacause of this my query to
select a specific date range doesn't work ,however when i click on the field
then it's recognized as a date and time field. I realy can't click on every
field to recognize it.
Does anyone know how to help me.
Thx

Reply to this Message

Gary''s Student - 05 Mar 2008 10:28 GMT

There are two approaches that may help:

1. Use the Import Wizard:
Data > Inport External Data > Import Data...
and tell the Wizard that the field is a Date

2. Use a small macro to "click-activate" all the cells at once. Select the
cells and run:

Sub wake_up()
Set saveit = Selection
For Each r In saveit
r.Select
Application.SendKeys "{F2}"
Application.SendKeys "{ENTER}"
DoEvents
Next
End Sub

Signature

Gary''s Student - gsnu2007e

> The problem is next I'm imoprting data from a database and this imported
> data consists os from a date_time and value. the problem is next, the time
[quoted text clipped - 4 lines]
> Does anyone know how to help me.
> Thx

Reply to this Message