Data Conversion Question

[AcceSs-AbLe]

Hello,

I am trying to convert a table to "CSV" format using the "Export Delimited" function in the macro. However, one of the fields don't get exported correctly. The field name is "ACCOUNT #" however, when exported, it only exports "ACCOUNT" the "#" isnt exported. What can I do to resolve this?

Thanks in advance!!

 

[Mile-O-Phile]

You can start by learning proper naming conventions in Access. It is not like a spreadsheet where you can give it all these funny names.

Access tolerates the use of some non-alphanumeric characters as field names but they are greatly advised against as is using spaces or undercores to split words in field or object names.

The better method is to condense the phrase into one length of text and capitalising each word within the text i.e. DateOfBirth

When people start using symbols, spaces, underscores, and reserved words as field names in Access then they are sure to run into problems in the future.