Hello all,
I want to import a txt.file in Access. If I do it manually, everything is OK. But if I want to do it by VBA : DoCmd.TransferText acImportDelim, "ImportSpecificationBasicFile", "BasicFile", GetImportFile(), True
where BasicFile the name is of the file where to import
GetImportFile() the name is of the file to import
then I receive at some places in the table strange characters :for exemple : Pavé d'Ath / Rue Félix Bovie / Rosières
It seems that there is a problem with the special french characters : é è ê, à ç ù
Could it be a prbl with the codepage? and so how can I resolve it and include in this VBA sentence?
Thanks in advance.