Macros and Programming

When I try to export cardbox to excel all the information for each record appears on one line.

I am doing

File
Transfer
Write

Write a comma delineated file

Under the file name a file called versons.txt comes up and I click on it and then ok.

When opening this file in excel everything all the record details are on 1 excel line.

Can you help please

Thanks

Kate

Which build of Cardbox Client you use?
Which version of Excel - which language?
Regards
Bert

Kate, have a look at the following:

If you have given the exported file the extension ".csv" and you double-click it, Excel will open it as if it were an Excel file, and it will look for TABS that seperate the fields.
However, when you export a file from Cardbox, the character used for seperation is the COMMA.

But, when you import the file in an empty Excel sheet instead of opening the file directly, you're asked which character seperates the data: TAB, semicolon, comma etc.
You can import the file using the 'Data' menu in Excel, or change the extension of your exported file to ".txt" and double-click it.

Make sure you select "comma", otherwise Excel will again look for TABS. Excel will now recognise your fields.

Hi Bert, we are using Excel 2007 and I am not sure how I find out which Cardbox client I am using?

Kate

Hi,
You can see which build of Carbox in Help - About.
I ask it because I remember there was a long time ago a bug in Cardbox which did strange things in this area (the bug is - as always - eliminated very quick after discovering).

One question: is one complete record in the first cel (which repeats for every record in first cel below) or are all records in the first cel?

kind regards
bert