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!
|
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).
|