By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,503 Members | 2,730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,503 IT Pros & Developers. It's quick & easy.

Importing Excel to Access Date/Time Format erroring

P: n/a
I've written a vba module that takes several .csv files and imports
them all into access using a pre-defined specification.

All is good if I set the spec up to import the following as text:

4/28/2006 11:44:13 AM

I really need to get this into access as a date where i can do
calculations to the second. It would be too much work to reformat all
the excel files as it would defeat the purpose of automating the
process in vba.

Any thoughts?

Thanks
-A

May 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
an**********@gmail.com wrote in
news:11**********************@v46g2000cwv.googlegr oups.com:
I've written a vba module that takes several .csv files and
imports them all into access using a pre-defined
specification.

All is good if I set the spec up to import the following as
text:

4/28/2006 11:44:13 AM

I really need to get this into access as a date where i can do
calculations to the second. It would be too much work to
reformat all the excel files as it would defeat the purpose of
automating the process in vba.

Any thoughts?

Thanks
-A

If you import to an existing table, you can add an extra column
to contain the converted datetime and run an update query after
the import.
--
Bob Quintal

PA is y I've altered my email address.
May 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.