Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Delimited Text Files (2000)

    If I try to import the attached delimited text file Jan.txt using File, Get External Data, Import, then, in the Import Text Wizard, click on the "Advanced" button, click on the "Specs" button and Open the "Italgen Import" Specification, I can then click on "Next" twice and select the existing table Italgen to store my data.
    But why, <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15>oh why, does this procedure work for Jan.txt but not for the equivalent feb.txt? The error message I get says, "Finished importing file '[path]feb.txt' to table 'Italgen'. Not all of your data was successfully imported. Error descriptions with associated row numbers of bad records can be found in the Microsoft Access table 'feb_Import Errors'" which lays the blame on a Type Conversion Error for the Data field but I don't see any difference in how the Data field is specified between Jan.txt and feb.txt.
    <img src=/S/help.gif border=0 alt=help width=23 height=15>
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Delimited Text Files (2000)

    You have also a problem with the jan.txt file. The date 31Jan02 is imported as 31/10/2002.
    I suspect you can't import to date fields when the month is not numeric.
    Import the txt files in a temporary table with the date field as text field and use an append query to transform your text field in a date field.
    Francois

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Delimited Text Files (2000)

    I've Imported feb.txt into the temporary table "Copy of Italgen" with the date field as text field and used an append query (AppendQuery) to transform the text field in a date field but when I run it I get the message in the attached picture.
    <font color=ff69b4>Ciao</font color=ff69b4>
    Attached Files Attached Files

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Delimited Text Files (2000)

    In your append query you have to transform the text field in date field.
    See the modified attachment.
    Just check the string with the month abbreviations that this are the abbreviations that you will get from the txt file.
    Attached Files Attached Files
    Francois

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Not in a million years...

    Interesting translation! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    J'adoube

    Hi Rory,
    Hmmm...Let's see <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Ooops! Involuntary pun with
    Well(Puits) done(fait)
    But maybe I could have gotten away by saying I meant Francois had done me a well of good with his reply. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    <font color=ff69b4>Ciao</font color=ff69b4>

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Not in a million years...

    Could I have thought of something like that.
    Tres bien fait! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •