Re: import to access from delimited file - file fields have change

Hi John,
Thanks. I couldn't figure out how to get back to this post for awhile, but
luckily I have found it again!!
More info so maybe you will have a clearer picture as to what I am talking
about;\

old txt file read (partial) "currency",trans code,serial no,"trans
desc",amount,imm avail,one day,two day

new txt file read (partial) "currencey",trans code,serial no,"trans
desc","trans desc 2",amount,imm avail,one day,two day

I added the new field trans desc 2 to the Import table, but when I
import the new txt file and then try to call up information everything has
shifted over and item to be reported in amount is reported in imm avail, etc.

Could you please help?

Thanks!
"John Nurick" wrote:

> Hi Girly,
>
> Normally the standard import routine (the one used by DoCmd.TransferText
> or File|Get External Data) can cope with CSV files that have line breaks
> in the data, as in this example
>
> 1,"Doe","John","This is a one-line comment","Last field"
> 2,"Roe","Jane","This is a two-line comment
> This is the second line of the comment","Last field"
> 3,"Poe","Edgar Allan","Nevermore","Last Field"
>
> Note that the file with the line break must be delimited (qualified) by
> quote marks.
>
> One possible cause of the problem you're seeing is that you are using an
> import specification and have not updated the import specification to
> reflect the new table structure. If that's not the cause, post back here
> with some more information about your data.
>
>
>
> On Thu, 2 Jun 2005 12:50:02 -0700, "girly"
> <girly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >I have been importing a comma-delimited file into an access database for
> >awhile. Now the file has changed and a new field (actually field now has 2
> >lines?) has been added and I can't get it to import properly. I have changed
> >the tables and added a new field. Now when I call up information everything
> >has shifted one field but not the correct information. Please Help!!!
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
>
.