Nothing changed with spreadsheets 2 and 3 deleted. There are no headers in the spreadsheet. The first row is data. The data for the first six columns loaded correctly.
I don't have an existing table to load the data to. I selected new table and it should list all the columns available and let me adjust the default data type and field length, etc. It only shows columns A - F as available?? There is no scroll bar for more columns like Gary mentioned. Warren -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Thursday, August 04, 2005 7:51 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Data Importing? At 10:26 PM 8/4/2005, Warren Glass wrote: >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, Just for my curiosity .. now that you have provided all details, how about deleting the 2nd and 3rd sheets from the XLS worksheet (make a backup copy first, of course) so that you only have one tab. Then, follow the same routine and see what you get. Very Best R:egards, Razzak.
