Using FileGateway to import Excel data is successful except that my preview doesn't show the right column. I am importing column W and the preview shows column A. The final result is correct though. Am I missing a setting? Excel range names don't appear to be available in this process.
Second, I have no idea what purpose the check boxes serve on the destination/source matching screen. It appears to work the same either way. Is there additional info on this feature? Third, is it possible to only import unique values through the File Gateway process? Thank you for any clarifications, I apologize for the many questions. Hans R:Base 9.1.4.10822 (64), Excel 2007 with file saved in .xls format for this purpose. --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
