I have not been able to use the wizard to import my 100 column plus spreadsheet.
I use Gateway and the wizard. I select new table and name it. I select the format, spreadsheet xls and I set the path and name to the spreadsheet. Next is START. The selection of available tables is sheet 1 2 or 3. I selected 1 where the data is. Now only available fields for columns A - F show and I set the data type and field size. This is only 6 of the 100 plus columns with data. How do I get the rest or can the wizard only handle up to six columns? I am using 7.5 latest version from Tuesday. Warren -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Warren Glass Sent: Wednesday, August 03, 2005 5:54 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Data Importing? I tried the Wizard and selected new table and selected my Excel file but it only columns A - F showed up for me name and select a data type and that's all that imported. Warren -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Wednesday, August 03, 2005 7:17 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Data Importing? At 12:21 AM 8/3/2005, Warren Glass wrote: >I have an Excel spreadsheet with exported QuickBooks data. >When I try to import Excel into a new Rbase table it only >brings in the first 6 columns of the 100 plus columns What >am I not doing correctly? Warren, Using the latest updates of R:BASE 7.1/7.5 for Windows, try the GATEWAY IMPORT Wizard option to fist map all Excel data with R:BASE table and then import the data. Hope that helps! Very Best R:egards, Razzak.
