format on data when using the wizard transfertext

Question

Hi

I use a macro-command called transfertext (from the list of available commands available within the macro). The thing is that the CSV file I import do have space for digit-grouping in number-formatted columns. These numbers does not get imported except if I remove the space beforehand in the CSV-file.

Is it possible to make access to remove the space  during the import or somehow else solve this problem?

Best Sverre

---

Sverreberre

Answer 1

I fear that you'll have to remove the spaces before importing into Access. Perhaps you can use Excel for this?

---

Regards, Hans Vogelaar