2 Replies Latest reply on Feb 14, 2014 7:03 PM by ejolesch_1

    Importing Data from Mac Excel using CSV

    ejolesch_1

      Title

      Importing Data from Mac Excel using CSV

      Post

           I have a problem trying to import data from an Excel spreadsheet.  I have a database that I use every year to help me organize my expenses, etc for tax purposes.  I create an empty copy of the database from the previous year, and it has worked ok in the past.  It's not a "pretty" db, just functional for me.

           My problem this year is I haven't been able to import the data (as a .csv) file correctly.  It won't import the amount.  In the db amount is a number, and I have saved my excel worksheet as a .csv file.  When I start the import I check the data, and the amount does show in the amount field, but when I import there are no amounts there.

           I have imported the file several times, erasing the data each time, and it won't import the amount.  I have looked at the raw .csv file and the amount looks correct.  I have also created a "new" db by importing the original spreadsheet and the amounts do import without any issues.

           Does anyone have any idea why my importing of the .csv file is not working correctly?  I'm sure it's something that I'm not doing right but I can't figure it out.

           Any insights are appreciated.

            

           Thanks

           Elliot

            

        • 1. Re: Importing Data from Mac Excel using CSV
          philmodjunk

               When I start the import I check the data, and the amount does show in the amount field, but when I import there are no amounts there.

               Exactly what import options are you selecting in that dialog box? Is the amount column in the excel file mapped to the correct field in your FileMaker table?

          • 2. Re: Importing Data from Mac Excel using CSV
            ejolesch_1

                 Phil -

                 Thanks, I really feel silly because the amount column wasn't mapped and I know better.  I was in a hurry and had changed the order around and just missed the fact that it wasn't mapped.... 

                 Now I have a new problem with a layout, but I will enter a new post for it....

                 Thanks