I am using Access 2003.
Try to link to a Unicode csv file supplied by a website host.
The result is a linked table with one field named '￾∀å�€æ¤€ç�€æ°€æ”€âˆ€â°€âˆ€ä˜€æ¤€çˆ€çŒ€ç�€ä¸€æ „€æ´€æ”€
∀Ⰰ∀䴀椀æ�€æ�€æ°€æ”€ä¸€æ„€æ´€æ”€âˆ€â°€âˆ€åŒ €æ”€æŒ€æ¼€æ¸€æ�€ä¸€æ„€æ´€æ”€âˆ€â°€âˆ€ä„€æ�€æ�€çˆ€ã „€âˆ€â°€âˆ€ä„€æ�€æ�€çˆ€ãˆ€âˆ€'. No data but the record
count is correct!
I have tried using the 'Advanced' button in the Link Wizard; Language
'English' and Code Page 'Unicode (Big-Endian)'.
The Wizard does not seem to recognise the 18 fields in comma delimited
format.
The import function produces the same result, except that the field
name is Field1. The error table shows, 'Unparsable Record'.
Tried to open the file in Excel. Error message received, "This file is
not in a recognizable format." Clicked OK to reveal a worksheet with
every record forced into column A. The header record, containing the
field names, has þÿ as the first two bytes.
Any help would be much appreciated.
Thanks.
Mike P.

I just run through SQL Server DTS, SSIS, MDB and Access Data Projects
until I can get the file to work






On Aug 12, 4:14Â*am, Mike P <mikewpa... (AT) tiscali (DOT) co.uk> wrote: