Generate Access report with fields containing comma?

[Guest]

I am trying to export Security entries from Hyena. One of the columns is "Object Name". In the case of users, this object name is in the form of "Lastname\, Firstname".

The problem is, when i tell it to generate an Access report on this data, The Access import splits up the Object Name value into two different columns.

Example:
<u>object name</u> <u>type</u>
Lastname\ Firstname

It seems that Hyena is putting in the '\' to escape the comma. That is cool, but it doesn't mean anything to Access.

I woudl be grateful for any ideas!

[cmccullough]

Re: Generate Access report with fields containing comma?

What you might want to try is using the Copy List Window rather than the Generate Report function. You would do a Ctrl-a to select all records, then a Ctrl-c to open the Copy List Window. There you can specify your delimiter, etc.

[Guest]

Re: Generate Access report with fields containing comma?

I did eventually figure that one out. It works nicely.

What i found interesting was that during the act of generating a report to access, Hyena actually checks the registry for LastDelimiterUsed or some other such variable.... it is as if the functionality is *almost* right there.

Another related thing: Might want to consider always using unicode for exporting information... I have some usernames with dashes or hyphens in them that export a little screwy...