Dennis,
If the Excel data were all CSV files, you could use SCONNECT using the JET
Text Driver and read it as an SATTACHED table.
----- Original Message -----
From: "Dennis McGrath" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, June 07, 2010 5:52 PM
Subject: [RBASE-L] - Re: Import from excel to 7.6
Nope, that didn't work.
But I did discover I could make a table 11 columns wide and import into
that.
I can extract what I need from that table.
Dennis
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Monday, June 07, 2010 4:39 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Import from excel to 7.6
Dennis: I've never actually done this, but my notes have the
following syntax:
GATEWAY IMPORT XLS filename APPEND customer
OPTION ADD_MAPPING Company=B
| ADD_MAPPING CustAddress=C
| ADD_MAPPING City=D
This would bring in only columns BC&D from the spreadsheet.
Karen
I need to import data from 150 excel spreadsheets into a table.
I only need to pull columns A, G, K
I can supply the filename of each spreadsheet.
What syntax can I use to accomplish this?
I was going to use the gateway interface, but the spreadsheets have almost
all possible columns populated.
Unclicking these is going to take forever!
If I could start the interface with the columns all unchecked it would be
easy.
Any suggestions?
Thanks,
Dennis McGrath
