Re: partial import errors

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: angie (angie_at_discussions.microsoft.com)
Date: 12/02/04 

Date: Thu, 2 Dec 2004 04:09:06 -0800

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" έγγραψε:

> [??-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?
>
> --
> Message posted via http://www.accessmonster.com
>

Relevant Pages

  • Re: carriage returns after import
    ... Select the data and Chip's add-in will show you what the characters are. ... The rectangles could be any one of a number of different characters. ... >>Gord Dibben Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: Yorkshire "sherbert" in ASCII IPA
    ... following Unicode characters: ... - glottal stop with stroke ... all I see are four rectangles. ... the characters you tried to show above all came out as rectangles on my rig. ...
    (alt.usage.english)
  • Re: partial import errors
    ... 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? ...
    (microsoft.public.access.externaldata)
  • Media Player 7.1 characters in task bar illegable
    ... I have Windows 98 and my Media Player 7.1's characters are illegable. ... come back in the task bar on the left hand side as little rectangles. ...
    (microsoft.public.windowsmedia.player)