I'd be interested in some general thoughts on what you have in mind. But, I
found an indirect solution: Create a table with field types I know will
accept the data, and use AppendDelimited. For some reason, that works. I
suspect that when you use the other method (im****t, with no table already
created), Pdox tries to "help" by guessing what each txt field should be.
But, when it sees an existing table, it shuts up and does what it's told.
"Steven Green" <greens@[EMAIL PROTECTED]
> wrote in message
news:47d03d90$1@[EMAIL PROTECTED]
> Joe.. we've discussed this very issue several times recently.. bottom
> line, it will take a ton of work to im****t that data.. much more work
than
> ex****ting it, once it's already there.. are you sure you really want to
go
> down this trail?
>
>
> --
> Steven Green - Myrtle Beach, South Carolina USA
>
> Diamond Software Group
> http://www.diamondsg.com/main.htm
> Paradox Sup****t & Sales
>
> Diamond S****ts Gems
> http://www.diamondsg.com/gemsmain.htm
> S****ts Memorabilia and Trading Cards
>
> "JoeSpareBedroom" <dishborealis@[EMAIL PROTECTED]
> wrote in message
> news:ikUzj.5632$7d1.5290@[EMAIL PROTECTED]
>> I've got a txt file with fields delimited by commas. One field contains
>> product descriptions, and many have words enclosed in quotation marks.
>> When using Tools, Im****t, Ascii, Delimited, Pdox has problems with
>> records containing those quotation mark-affected words. So, the im****t
>> never proceeds. I could do a search-replace on the txt file and remove
>> all the quotation marks, but that presents another problem: Some
>> descriptions also contain stuff like
>>
>> paper plates 10"
>>
>> ...where that 10 inch designation is im****tant, so I don't want to
remove
>> ALL quotation marks.
>>
>> How do I tell Pdox to ignore quotation marks completely during the
>> im****t, and focus only on the commas? I seem to recall a way of
adjusting
>> im****t parameters, but it's been too long since I did this. I see
nothing
>> in the menus.
>>
>
>
|
