partial import errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to import a text file into access. the problem is that a particular
field is not imported at all. i have set the field type to memo since the
data in this particular field might be even two rows. could the problem be
that? or is it because i have eleven columns to import? is there a limit on
that?

alternatively what could be the problem? could it be in the import
specifications? but if there was a problem with the specifications wouldn't i
be facing problems with the other fields too?

pls help me!!!
 
It would help if you could put some sample lines from the text file and the layout of the table you're trying to import it into. From the sounds of it, you may be having trouble with the "particular field might be on two rows", because text files containing carriage returns in fields inside the column don't import very well...
 
sample text import:[€Â-321615301C;ƒˆ‘‰ŽÂŠ€‰„‘
„‹ÂÂ.;S„;;ƒˆ;0,00;0;0,000;BR-09/4765/10;BO-0986478017;AUDI 80,COUPE,CORDOBA
99-02,IBIZA 93-02,GOLF I/II/III,PASSAT]
from the text file i have problem importing the following part:
AUDI 80,COUPE,CORDOBA 99-02,IBIZA 93-02,GOLF I/II/III,PASSAT]
in the table i have assigned the memo property to the field.

does this help?

Ο χÏήστης "David Seeto via AccessMonster.com" έγγÏαψε:
 
[??-321615301C;???????????
????.;S?;;??;0,00;0;0,000;BR-09/4765/10;BO-0986478017;AUDI 80,COUPE,CORDOBA 99-02,IBIZA 93-02,GOLF I/II/III,PASSAT]

It does help a bit, but I still have some questions -
* Is this a single line from the file you're trying to import from?
* I recognise the Euro signs, and the number formats indicate that you're using commas instead of full stops for the decimal point, but what are the characters that appear as rectangles?
* Are the fields separated by the semi-colons?
* What's the names of the fields of the table you're trying to import this into?
 
1.this part of the text file constitutes a single line or field:AUDI
80,COUPE,CORDOBA 99-02,IBIZA 93-02,GOLF I/II/III,PASSAT]
2.the characters that appear as rectangles are greek language, when i import
the file i do not have a problem with that.
3.yes, the fields are separated by semicolumns
4.the names of the fields i try to import the text file into and the
corresponding data types are:
code(test),description(memo),family(text),group(text),category(text),sell
price(currency),units in stock(number),purchase price(currency),special
code(text),alternative code(text) and long description(memo).
perhaps it would help if i told you that the language i select in the
advanced tab during the import is greek and the code page is greek(dos).

Ο χÏήστης "David Seeto via AccessMonster.com" έγγÏαψε:
 
Hm, I don't have Greek installed on my computer here, but that shouldn't be affecting it. I'm having trouble reproducing your problem - I've put your sample line into a text file and importing it into a test database intoa table set up as you describe, and it's imported ok, with values:
Code = ??-321615301C
Description = ??????????? ????.
Family = S?
Group = (Null)
Category = ??
Sell Price = $0.00
Unit in Stock = 0
Purchase Price = $0.00
Special Code = BR-09/4765/10
Alternative Code = BO-0986478017
Long Description = AUDI 80,COUPE,CORDOBA 99-02,IBIZA 93-02,GOLF I/II/III,PASSAT

What do you get in the various fields if you try to import a text file with just this line in it?
 
if i import just this line it is imported ok, could it be because not all the
data in the text file contain a value in this field?

Ο χÏήστης "David Seeto via AccessMonster.com" έγγÏαψε:
 
if i import just this line it is imported ok, could it be because not all the data in the text file contain a value in this field?

No, that doesn't hurt it - it just puts blanks into the field.

I think the problem is what you first mentioned about the "data might be in two rows"... does that mean your text file might have one line going over two rows, like this:

1;Audi;F;G;C;1,000;0;1,000;SC;AC;AUDI 80, <break>
COUPE, CORDOBA

If this is happening, the Improt Wizard will try to import the second line (COUPE,CORDOBA) into a separate record. When importing from a text file, you have to make sure that all of the data is on the one row... you have to either stop it from going over two lines in the first place, or clean it up afterwards. Unfortunately, I can't think of any programs smart enough to do clean this sort of thing automatically, so you'd have to do it manually yourself...
 
Back
Top