If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing a timestamp
I was importing a text file with a timestamp into a new table using the
import wizard. I have set the advanced to be the correct date format. But I can not get the timestamp to import. The timestamp has the following format. yyyy-mm-dd hh:nn:ss.sssssssss I do not know how to set the format for a field during the import. Guess I could import to an existing table, but I do not know the format pattern for the above timestamp in the designer. Another question. During the import wizard, how can you set the length of the text fields during import. Thanks |
#2
|
|||
|
|||
Access won't work with the decimal second part: it's only designed to hold
yyyy-mm-dd hh:nn:ss. Try importing it as text, then write an Update query to remove everything after the decimal point. Once you've done that, you can add a Date/Time field to the table and write another Update query to populate the Date/Time field with the value of the Text date field (using the CDate function) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Brenda" wrote in message ... I was importing a text file with a timestamp into a new table using the import wizard. I have set the advanced to be the correct date format. But I can not get the timestamp to import. The timestamp has the following format. yyyy-mm-dd hh:nn:ss.sssssssss I do not know how to set the format for a field during the import. Guess I could import to an existing table, but I do not know the format pattern for the above timestamp in the designer. Another question. During the import wizard, how can you set the length of the text fields during import. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing ** Wab from Outlook Express into Outlook Address Book | amorosa | Contacts | 0 | July 30th, 2004 10:51 PM |
Importing contacts from OL to OE using a csv file does not work | Rick | Contacts | 1 | April 27th, 2004 09:25 PM |
importing | Lisa | Worksheet Functions | 1 | January 29th, 2004 09:54 AM |