Import xls sheet

[Plucky]

Hi

I receive daily job orders in a Microsoft Excel Spreadsheet. One job per Excel Spreadsheet.

The .xls files are made up of 3 sheets but I only need information on sheet 2.

Sheet 2 is spread over 13 rows and 46 columns. In all there is over 200 cells with either text, number or date information.

I only require about 30 cells to be imported into my Filemaker solution.

What I can't do is somehow mark the required cells I need in XL so let my Filemaker script knows to import these.

Filemaker seems to only import information on individual rows per record.

Does anyone know if this can be done or should I be looking at applescript?

[bcooney]

How about creating a worksheet that only contains the 30 cells that you need, referenced back to Sheet 2.

FM sees each XL row as a record.

[Plucky]

Hi

That's an idea, The problem I have that it's a worksheet that gets passed around a lot of companies so that they can access the information they require from each sheet, so being able to have access to the original master to amend may be difficult. I really needed to know if I was doing something wrong or that there is no way to extract data from multiple rows to go into one FM record.

Thanks for your help.

Regards

Peter

[James Marshall]

Hi Plucky,

The only way I can see getting multiple excel rows into one FileMaker row is to make a "scratch" table in FileMaker and then script out adding data from xx rows in the scratch table to a return delimited field in the primary FileMaker table.

Good luck,

James

http://www.soliantconsulting.com/blog/category/filemaker/