Data Quality Tools, Mailing Software, Lists, NCOA, Data Enhancements

 | Shopping Cart Buy | Newsletters | Search

    Products         Solutions       Downloads & Trials       Support          Resources         Lookups       Contact Us  

Logged in as: Guest Search | Active Topics |

Problems with Excel Tables Options · View
Tim61468773
Posted: Tuesday, January 29, 2008 10:52:12 AM
Groups: Administration

Posts: 16
Any known issues, tips or suggestions are welcomed here.

TIP #1: Read the MatchUp help file section Help | Contents | Reference | FAQ | Access/Excel Specific Questions. There are already some good workable solutions out there!
Tim61468773
Posted: Tuesday, January 29, 2008 10:58:26 AM
Groups: Administration

Posts: 16
Output Tables: Avoid pitfalls when writing to Excel by creating Table names and field sizes which conform to other database structures (which may be present in the same setup as your Excel table).

Make the Output Table name a single word, and a name which is unique (does not exist in the current .xls). We have seen Excel fail to drop an existing table it is supposed to overwrite, and have reported crashes when an Output Table name contain spaces (multiple words).
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by Yet Another Forum.net