Jump to content

Exporting into Excel


stonecali
 Share

This topic is 7623 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Can you export data from Filemaker directly into an Excel spreadsheet into specific cells? Right now I am just importing into Excel into one worksheet all in the same row, then the second worksheet puts the data into the right place. But then when I save the excel file to email to my customer, I have to reformat so that just one worksheet shows so as not to confuse them. I was just hoping that FMPro 5.0 and the newer versions on MS Excel would save me some time.....

Thanks!

Link to comment
Share on other sites

quote:

Originally posted by WBlanchard:

Export your data from FMP into a tab delimited text file. Open Excel and then open the text file from within Excel. Excel will take you thru a wizard process that will allow you break the data into individual cells.

Try a Comma seperated file, Excel seems to autodetect these a little better.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

You ASKEd: Originally posted by stonecali:

Can you export data from Filemaker directly into an Excel spreadsheet into specific cells?**********************

We export out of FileMaker Pro all day long, but we export to a DBase (DBF) file. Excel automatically opens it all in the right fields. It's easy, quick and the only thing we have to format is the date fields and if necessary the money fields depending on the client. Also, if you save a file in Excel as a dbf, it imports into FileMaker Pro better.

Gina @ Computeach

Link to comment
Share on other sites

This topic is 7623 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.