get date/time into the same column?

[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

 

[John W. Vinson]

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?

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.

 

[Geoff Cox]

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.

John,

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

Thanks

Geoff

 

[Geoff Cox]

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.

John,

cannot see how to do this! any pointers?

Thanks

Geoff

 

[John W. Vinson]

John,

cannot see how to do this! any pointers?

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.

 

[Geoff Cox]

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.

John,

thanks for the above - all is well agin!

Cheers

Geoff