Dan,
Apparently the only limitation to using the dbf import was
the number of columns it accommodates. You said your Excel
file has 169 and dbf allows only 128.
Perhaps you could add an autonumber field to your
Excel table, split the table in half, export as dbf making
sure you have the autonumber field in each half, attach the
dbf file, project an RBast table from both, then join
the columns together in RBase from both tables using that
common field.
You can make an 'autonumber' field in Excel by
putting 1 in the first row of an empty column
(such as a newly inserted column A). On the next row
the formula is
=+A1 + 1
If you copy this formula from row two to the bottom
of your data it will consecutively number each row.
(If column B has data in each row you can use it to help
you quickly populate the row. Put cell A2 in the clipboard
by using the copy icon or right click the mouse and select copy.
Press right arrow key, end + down arrow, left arrow key.
This will place you at the bottom data row for column A.
With the shift key pressed, press end + up arrow. Keep
the shift key pressed down and press the down arrow. That will
place you on the second line of Column A with all the rows
to be numbered highlighted.
Press the enter key. All rows should be consecutively
numbered .)
Randy Peterson.
Texmaster Express wrote:
> Good afternoon.
>
> I'm still working on the data conversion routine from Hades. I've decided to
> use the Gateway command since it seemed to work once before. I've saved my
> Excel file to an XLS3 format (am using Excel 2002) and run the command:
>
> gateway import xls3 ords.xls replace orders
>
> I've also tried a variant of the above,
>
> gateway import xls3 ords.xls create x
>
> In each instance, R:Base returns the error message:
>
> Cannot import a table with 0 columns
>
> I've checked my source table in Excel and it reads just fine. I've also
> checked to be sure I have an equal number of columns.
>
> I've also tried saving the file as a dbf, attaching it and projecting it,
> but the Excel file has 169 columns, and the dbf file will only allow 128.
>
> Any suggestions? (Besides convincing our software company to use Oterro,
> which I've already tried)
>
> Dan
