Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I'm trying to export a temp table,

Status
Not open for further replies.
youwannawhat

youwannawhat

Programmer
Oct 3, 2001
43
US
I'm trying to export a temp table, containing a character field and a memo field, to Excel. The Memo field is not resolving. How can I get the Memo field to export with the other field?

Thanks
 
Sort by date Sort by votes
Thanks, anyway. I figured it out.

SELECT left(a.field, 400) as memo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

1962dez
  • Question
Export to Text file
Replies
4
Views
354
Chriss Miller
C
Sydney Savoy
  • Question
"Printer not ready", but client is not trying to print
Replies
9
Views
444
tomk3
tomk3
L
  • Locked
  • Question
Error when trying to publish web service
Replies
3
Views
501
Chris Miller
Chris Miller
SitesMasstec
  • Locked
  • Solved
Copy fields from one table to another
2
Replies
26
Views
2K
SitesMasstec
SitesMasstec
Mandy_crw
  • Question
What is the correct or best approach in editing a table? 7
Replies
17
Views
974
Chriss Miller
C

Part and Inventory Search

Sponsor

Back
Top