We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
When you import your file (csv) into Access, you can select semi-colon as your delimiter, and the Solicitors will appear in different columns. However, if that doesn't work, a workaround might be using Query to export the Solicitor names in different rows (not columns). And then copy and paste into columns. I know you could do the same after a regular Export, but it might be easier to copy if they are in different fields (as opposed to one field with semicolons).
And, Happy Birthday!
-Sarah
__________________ Sarah Hull
Renegade Researcher
Somewhere in New Jersey
"Isn't life wonderful, Brain? Just think, we started out as lab mice forced to spend the whole day working our way through frustrating mazes that went absolutely nowhere. Now we get to do what humans do!" -Pinky
Last edited by hullsa; 04-30-2007 at 12:22 PM.
Reason: happy birthday!
When you import your file (csv) into Access, you can select semi-colon as your delimiter, and the Solicitors will appear in different columns. However, if that doesn't work, a workaround might be using Query to export the Solicitor names in different rows (not columns). And then copy and paste into columns. I know you could do the same after a regular Export, but it might be easier to copy if they are in different fields (as opposed to one field with semicolons).
First, she is exporting directly to MS Access. You don't have this option when you are exporting directly to Access, only when you are importing a text file into Access.
Second, this will only work if you can guarantee that every record has exactly the same number of solicitors, which almost never happens. If you don't have the same number of solicitors in each record, then the rest of the columns will get shifted depending on the number of solicitors. This will cause problems because your records will not have the same number of columns (violating first normal form), subsequent columns will be misaligned, and if your columns are typed as something other than text (e.g., date, amount, etc.), you will likely get type conversion errors.
Drew
__________________ J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
__________________ Sarah Hull
Renegade Researcher
Somewhere in New Jersey
"Isn't life wonderful, Brain? Just think, we started out as lab mice forced to spend the whole day working our way through frustrating mazes that went absolutely nowhere. Now we get to do what humans do!" -Pinky
Katherine Spitler
Linear Mode
