Problem Importing A Flat File Into Access 2007

[hlint09]

I import a lot of data from A Concordance database (basically I import from text files). In previous versions of Access I can import the files with no trouble but the new one gives problem. The delimiters used are:

Field delimiter: chr(20)
Text Qualifier: chr(254)

For example:
þHectorþþNew yorkþþþþþþþþþþAdobe Acrobat (PDF)þ

This delimiters are very good because rarely they will be on the text data of any record but Access do not accept the file forcing me to change the delimiters. Do you know why?

Thank you

 

[genomon]

Since the characters won't even render in your post above, I would guess you need to use characters that are included in your default font.

Ever notice how fast Windows runs? Me neither.

 

[hlint09]

Thank you for answering

chr(20) = 
chr(254)=þ

That is their representation and when Imported like that in Access 2003 and before the data get imported with no problems.

 

[genomon]

Chr(20) has no representation in ANSI, although OEM sees it as a paragraph symbol. Unfortunately ANSI is the standard (hence the "S"). What country are you posting from? Possibly you could set up to run on Unicode?

Ever notice how fast Windows runs? Me neither.

 

[genomon]

FYI the ANSI char 182 is the paragraph diacritical.

Ever notice how fast Windows runs? Me neither.

 

[hlint09]

I am in NYC and those special characters are the standard delimiters for a broadly used database called Concordance from the company Lexis Nexis. Again, prior versions of Access use to import the data without major hassle but for some reason they are not importing it anymore and I am just trying to find a way without having to change the character(if there is one)

Thank you

 

[genomon]

Since ANSI likes chr 254, try changing Field delimiter: chr(20) to Field delimiter: chr(182) in your code and see if there is any love there.

Ever notice how fast Windows runs? Me neither.