Thanks to Beverly and to Stephen. I was able to import using .XLSX. Don't know why I didn't experiment with that earlier. Doh! Worked well.
Deb Deborah Tinsley Visual Resources Kansas City Art Institute [email protected] 816.802.3395 "Give a man a fire and he's warm for a day, but set fire to him and he's warm for the rest of his life." Terry Pratchett, Jingo On Mon, Feb 24, 2014 at 1:05 PM, BEVERLY VOTH <[email protected]> wrote: > use CSV, but instead of selecting 'csv', select 'mer' (merge) in the > export dialog. The field names will be the first row, otherwise it is the > same as CSV. Excel (any version) should be able to open that. > > In addition Excel can open a .htm TABLE, if exporting as HTML Table would > do what you want. Keep the extension as .htm and the columns also should be > the first row. > > The problem may come if your Export is to Excel that actually is to .xlsx > and not .xls and older versions cannot open the file. > > Beverly > > > On 24 Feb 2014, at 1:09 PM, Deborah Tinsley wrote: > > I need to export FMP Data to Excel. Any suggestions? > I need to flatten FMP Data. > > Deb > > Deborah Tinsley > Visual Resources > Kansas City Art Institute > [email protected] > 816.802.3395 > > > "Give a man a fire and he's warm for a day, but set fire to him and he's > warm for the rest of his life." Terry Pratchett, Jingo > > > On Mon, Feb 24, 2014 at 10:08 AM, Stephen Wonfor <[email protected]>wrote: > >> Deb >> >> I have a number of clients who we have setup Excel exports that they run >> every day. OSX 10.9.1 and Office2008. >> If you are running 10.9 ( and I think 10.8) you need to export as .XLSX >> and not .XLS. >> >> Stephen >> >> ---- >> >> "In software, we rarely have meaningful requirements. Even if we do, the >> only measure of success that matters is whether our solution solves the >> customer's shifting idea of what their problem is." --- Jeff Atwood >> >> Stephen >> >> ---------- >> >> "The year was 2081, and everyone was finally equal." -- Kurt Vonnegut >> >> On Feb 24, 2014, at 8:55 AM, Deborah Tinsley <[email protected]> wrote: >> >> Hey all, >> I'm starting to use a new Visual Resource storage and presentation >> software called Shared Shelf (put out by ArtStor). To download my FMP >> files, I first have to flatten the data. Before, when I had FMP 7, I always >> just used the export function. >> Exporting FMP 12 data to Excel for Mac 2008 does not work or at least I >> can't get it to work. Any suggestions? Is there another way to flatten data? >> >> Deb >> Deborah Tinsley >> Visual Resources >> Kansas City Art Institute >> [email protected] >> 816.802.3395 >> >> >> "Give a man a fire and he's warm for a day, but set fire to him and he's >> warm for the rest of his life." Terry Pratchett, Jingo >> >> >> > >
