get date/time into the same column?

  • Thread starter Thread starter Geoff Cox
  • Start date Start date
G

Geoff Cox

Hello,

I have records like

2008-05-16 11:58:43 2 (e-mail address removed) 1 5 NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL

How do I get these into Access 2003 keeping the date/time, i.e. the
2008-05-16 11:58:43 in the same column?

I would expect to use a space to separate the fields but that cannot
work if I want to keep the date/time in the same column?

Help!

Cheers

Geoff
 
Hello,

I have records like

2008-05-16 11:58:43 2 (e-mail address removed) 1 5 NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL

How do I get these into Access 2003 keeping the date/time, i.e. the
2008-05-16 11:58:43 in the same column?

I would expect to use a space to separate the fields but that cannot
work if I want to keep the date/time in the same column?
Click to expand...

Is this a text file or a table? If it's a Text file, use File... Get External
Data... Import, and use Advanced to set up an import specification.
 
Is this a text file or a table? If it's a Text file, use File... Get External
Data... Import, and use Advanced to set up an import specification.
Click to expand...

John,

It is a text file - I will try what you say.

Thanks

Geoff
 
Is this a text file or a table? If it's a Text file, use File... Get External
Data... Import, and use Advanced to set up an import specification.
Click to expand...

John,

cannot see how to do this! any pointers?

Thanks

Geoff
 
John,

cannot see how to do this! any pointers?
Click to expand...

Open your database; use File... Get External Data... Import. From the dropdown
list at the bottom of the window (labeled "Files of type") choose Text Files.
This may be tricky and may require some pre-processing of the text file if you
have variable length fields though! I can't immediately see how to use blanks
as the delimiter without it importing the date and time as separate fields.

If you do so, you can reconstruct a date/time value by simply adding the date
to the time, numerically: an update query updating a date/time field to

[datefield] + [timefield]

will combine them correctly.
 
Open your database; use File... Get External Data... Import. From the dropdown
list at the bottom of the window (labeled "Files of type") choose Text Files.
This may be tricky and may require some pre-processing of the text file if you
have variable length fields though! I can't immediately see how to use blanks
as the delimiter without it importing the date and time as separate fields.

If you do so, you can reconstruct a date/time value by simply adding the date
to the time, numerically: an update query updating a date/time field to

[datefield] + [timefield]

will combine them correctly.
Click to expand...

John,

thanks for the above - all is well agin!

Cheers

Geoff
 
Back
Top