transfer to excel


B

Bill H.

If I open up an Access (2000) table and use the tools, office links, analyze
with Excel, the Boolean fields are translated as TRUE/FALSE (that's good),
but a memo field is getting truncated.

If I export from Access to CSV, the Boolean come out as 1/0, but the memo
field comes out just fine. If I then import to Excel that .csv file, the
memo field is all there (as is the 1/0 for the Boolean field).

So, how do I get the Boolean to come out TRUE/FALSE and the memo to not get
truncated? Yeah, I could manually or via Excel macro (I guess), change the
1/0 to true/false, but I'd rather use just one step in the export process
and have it be all correct the first time.

Thx.
 
Ad

Advertisements

J

Jeff Boyce

Bill

Have you tried using a query to "condition" the data into the format you
want, then export the query?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top