I have had some problems getting import specifications to work also. I made
a work around for it. First I import the values into a temporary table.
Next I use an append query to append the values in the temporary table to
the real table with the formatting that I want -- changing data types from
strings to dates, etc.
Hope this helps.
Linda
<pietlinden@hotmail.com> wrote in message
news:1123518573.461057.38450@z14g2000cwz.googlegro ups.com...[color=blue]
>I almost feel stupid posting this, but maybe someone else understands
> what's going on here.
>
> I am importing a delimited text file, and have saved an import
> specification so that for the user the whole thing is essentially
> pushbutton. Except for some reason, it seems my import spec thinks
> summer is a good time to pack up and go on vacation, so when the user
> tries to run the import, I get error 3265 (missing spec), and the
> import obviously fails. If I run an import with a "bad" spec and the
> code crashes, does it lose my spec?
>
> The text file I'm importing is fairly simple - essentially a CSV file
> with headers. So I guess I could take Chuck's advice and use his
> stuff. I was just thinking that this would be simpler...
>
> Any easy way around this, or is this a case of
>
> Patient: "Doc, it hurts when I..."
> Doctor: "Well, don't do it, then!"
>
> Thanks
> Pieter
>[/color]
