Hello Warren: I import a lot of excel spreadsheets with a lot more than 6 columns and I have no problems.
If you are using the wizard then you have to manually map the columns in excel to the columns in your database. This would start at example a and go through column whatever once these columns are mapped you should have no problems exporting the data. What I have done to automate this process is mapped the spreadsheet with tables once to make sure that the structure matches and then I wrote a command file using a command like this GATEWAY IMPORT xls filename REPLACE tablename OPTION sheet_index 0 This will import the excel spreadsheet into the table and replace the existing data. The trick is matching up the column data type that is in the spreadsheet with the column type in rbase. I have written several applications using this and it works like a charm. Hopes this helps Larry -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Warren Glass Sent: Thursday, August 04, 2005 7:27 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Data Importing? 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.
