Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memos to Excel
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00380879
Message ID:
00381339
Views:
11
>I didn't find any quick fix. I tried variations of COPY TO using the old 2.x format and whatnot and had no luck. The only thing that worked was Automation.

Bingo! A little shuffling, and I've got it, a nice neat Excel sheet. Here is the sequence:

1) Access imports VFP data into Access DB, preserving memo length.
2) Access exports to Excel, again preserving memo length, and even placing all memo EOLs in the same Excel cell (so the text will show up properly formatted in that "tooltip" popup feature that Excel uses).

By golly, that's the first useful thing I've ever found for MS Access <s>
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform