Prev: I GOT $2500 FROM PAYPAL....
Next: Error Message in 2002
From: Salad on 5 Aug 2010 11:56
Thomas Andersson wrote:
> Salad wrote:
>
>
>>Expanding on what Karl wrote.
>>
>>I did not get an error like you descibed that but it may be due to me
>>manually doing a simple File/GetExternalData/Import and importing the
>>data from a text file. The result I get for a date field like yours
>>is #Num in the column. However, if I change the text file to
>>alsoinclude a year it imports fine. So if you wrote a script that
>>can get the month, day, hours, minutes could you now also add a year?
>>If you can't, Karl's advice is spot on, IMO.
>
>
> Adding a year is simple so I'll try that (just concatenate it in front of
> the variable).

I had 2 cols. One col might have looked like
08/05/2010 11:;30
and the other
Aug 5 2010 11:30
and both appended fine. Not sure what you mean "in front of variable".

> One related question. My DB also ahve auto number and to let it be generated
> by DB I can select to skip that column during inport. Q though is. Should I
> leave the import rows as is (starting with the first non auto data) or
> insert a empty tab at start of each row so column numbers match?
>
>
I'm sorry. I really don't understand the question/issue. Do realize
that I was manually doing it. I ran a query to export my results using
Docmd.TransferText acExport....
So I could have used it as well to import, changing acExport to
acImport. I recommend saving to a file specification for importing the
specified layout.

I don't understand "inserting an empty tab". If you need a flag field,
create a flag field.

First  |  Prev  | 
Pages: 1 2
Prev: I GOT $2500 FROM PAYPAL....
Next: Error Message in 2002