John, Automation is your friend here... If you need an assist then shout...
Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of John Weller Sent: 12 February 2013 10:44 To: [email protected] Subject: Import From Excel I have some data in the form of an Excel spread sheet which I want to import into a table. The problem is that one column has some entries that are more than 254 characters. I want to import that into a memo field but APPEND does not support appending into memo fields and APPEND MEMO appears to just append one text file to one field. Any suggestions? If all else fails I will split them by hand into 200 character blocks and then concatenate them once they are imported but as there are about 300 rows I'd prefer to do it as a programme. John Weller 01380 723235 07976 393631 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
