Creating an *.iif File from Excel

Discussion in 'Quickbooks' started by John Baker, Aug 5, 2004.

  1. John Baker

    John Baker Guest

    Hi:

    I just started exploring how to import Payroll and Invoice data into Quickbooks, and see
    that you can import from Excel by creat8ing a *.iif file. Unfortunately, my version of
    Excel (Office 2000) does not offer that extension when saving a file. Can someone tell me
    how to create an *.iif file from Excel.

    Thanks

    John Baker
     
    John Baker, Aug 5, 2004
    #1
    1. Advertisements

  2. John Baker

    Gary Guest

    Hey John,

    Do save from Excel, just choose Text (tab delimited) as your option to save
    as. After you have saved, use explorer to locate the folder and the file,
    right click on the file and change the name from .txt to .iif. It may be
    easier to do if you have unchecked the box under explorer that says hide
    extensions of known file types.

    Another way is to choose Text (tab delimited) as your save as type while in
    Excel, in the file name dialog box put the filename in quotes such as
    "payroll.iif", it will then save that name as a delimited file.

    cheers
    gary

    "John Baker" <> wrote in message
    news:...
    > Hi:
    >
    > I just started exploring how to import Payroll and Invoice data into

    Quickbooks, and see
    > that you can import from Excel by creat8ing a *.iif file. Unfortunately,

    my version of
    > Excel (Office 2000) does not offer that extension when saving a file. Can

    someone tell me
    > how to create an *.iif file from Excel.
    >
    > Thanks
    >
    > John Baker
     
    Gary, Aug 5, 2004
    #2
    1. Advertisements

  3. John Baker

    John Baker Guest

    Thank you...thats very helpful

    Best

    John

    "Gary" <> wrote:

    >Hey John,
    >
    >Do save from Excel, just choose Text (tab delimited) as your option to save
    >as. After you have saved, use explorer to locate the folder and the file,
    >right click on the file and change the name from .txt to .iif. It may be
    >easier to do if you have unchecked the box under explorer that says hide
    >extensions of known file types.
    >
    >Another way is to choose Text (tab delimited) as your save as type while in
    >Excel, in the file name dialog box put the filename in quotes such as
    >"payroll.iif", it will then save that name as a delimited file.
    >
    >cheers
    >gary
    >
    >"John Baker" <> wrote in message
    >news:...
    >> Hi:
    >>
    >> I just started exploring how to import Payroll and Invoice data into

    >Quickbooks, and see
    >> that you can import from Excel by creat8ing a *.iif file. Unfortunately,

    >my version of
    >> Excel (Office 2000) does not offer that extension when saving a file. Can

    >someone tell me
    >> how to create an *.iif file from Excel.
    >>
    >> Thanks
    >>
    >> John Baker

    >
     
    John Baker, Aug 5, 2004
    #3
  4. John Baker

    John Baker Guest

    Gary:

    Do you know of any piece of software that will do this automatically? I have an
    unsophisticated user who will mess up the process of changing the extension.

    Best

    John

    "Gary" <> wrote:

    >Hey John,
    >
    >Do save from Excel, just choose Text (tab delimited) as your option to save
    >as. After you have saved, use explorer to locate the folder and the file,
    >right click on the file and change the name from .txt to .iif. It may be
    >easier to do if you have unchecked the box under explorer that says hide
    >extensions of known file types.
    >
    >Another way is to choose Text (tab delimited) as your save as type while in
    >Excel, in the file name dialog box put the filename in quotes such as
    >"payroll.iif", it will then save that name as a delimited file.
    >
    >cheers
    >gary
    >
    >"John Baker" <> wrote in message
    >news:...
    >> Hi:
    >>
    >> I just started exploring how to import Payroll and Invoice data into

    >Quickbooks, and see
    >> that you can import from Excel by creat8ing a *.iif file. Unfortunately,

    >my version of
    >> Excel (Office 2000) does not offer that extension when saving a file. Can

    >someone tell me
    >> how to create an *.iif file from Excel.
    >>
    >> Thanks
    >>
    >> John Baker

    >
     
    John Baker, Aug 7, 2004
    #4
  5. John Baker

    Gary Guest

    John,

    Sorry I don't know of any process that does this automatically. However if a
    person opens an existing IIF file, Excel will import. Then you can click
    save and it will retain the name. I also suppose one could create a macro
    (or via code) to assist the user.

    Gary

    "John Baker" <> wrote in message
    news:...
    > Gary:
    >
    > Do you know of any piece of software that will do this automatically? I

    have an
    > unsophisticated user who will mess up the process of changing the

    extension.
    >
    > Best
    >
    > John
    >
    > "Gary" <> wrote:
    >
    > >Hey John,
    > >
    > >Do save from Excel, just choose Text (tab delimited) as your option to

    save
    > >as. After you have saved, use explorer to locate the folder and the file,
    > >right click on the file and change the name from .txt to .iif. It may be
    > >easier to do if you have unchecked the box under explorer that says hide
    > >extensions of known file types.
    > >
    > >Another way is to choose Text (tab delimited) as your save as type while

    in
    > >Excel, in the file name dialog box put the filename in quotes such as
    > >"payroll.iif", it will then save that name as a delimited file.
    > >
    > >cheers
    > >gary
    > >
    > >"John Baker" <> wrote in message
    > >news:...
    > >> Hi:
    > >>
    > >> I just started exploring how to import Payroll and Invoice data into

    > >Quickbooks, and see
    > >> that you can import from Excel by creat8ing a *.iif file.

    Unfortunately,
    > >my version of
    > >> Excel (Office 2000) does not offer that extension when saving a file.

    Can
    > >someone tell me
    > >> how to create an *.iif file from Excel.
    > >>
    > >> Thanks
    > >>
    > >> John Baker

    > >

    >
     
    Gary, Aug 7, 2004
    #5
  6. John Baker

    John Baker Guest

    Gary:

    Thanks.. that points me in he right direction.

    .. Out of Access, I will create a file .xls format containing the appropriate data.
    .. I will program have an .xls spreadsheet which will contain macros which will
    . open an .iif file the appropriate name
    . clear out the current contents
    . copy the Access produced xls data into the iif file
    . and then save it.

    I think that will work.

    best

    John

    "Gary" <> wrote:

    >John,
    >
    >Sorry I don't know of any process that does this automatically. However if a
    >person opens an existing IIF file, Excel will import. Then you can click
    >save and it will retain the name. I also suppose one could create a macro
    >(or via code) to assist the user.
    >
    >Gary
    >
    >"John Baker" <> wrote in message
    >news:...
    >> Gary:
    >>
    >> Do you know of any piece of software that will do this automatically? I

    >have an
    >> unsophisticated user who will mess up the process of changing the

    >extension.
    >>
    >> Best
    >>
    >> John
    >>
    >> "Gary" <> wrote:
    >>
    >> >Hey John,
    >> >
    >> >Do save from Excel, just choose Text (tab delimited) as your option to

    >save
    >> >as. After you have saved, use explorer to locate the folder and the file,
    >> >right click on the file and change the name from .txt to .iif. It may be
    >> >easier to do if you have unchecked the box under explorer that says hide
    >> >extensions of known file types.
    >> >
    >> >Another way is to choose Text (tab delimited) as your save as type while

    >in
    >> >Excel, in the file name dialog box put the filename in quotes such as
    >> >"payroll.iif", it will then save that name as a delimited file.
    >> >
    >> >cheers
    >> >gary
    >> >
    >> >"John Baker" <> wrote in message
    >> >news:...
    >> >> Hi:
    >> >>
    >> >> I just started exploring how to import Payroll and Invoice data into
    >> >Quickbooks, and see
    >> >> that you can import from Excel by creat8ing a *.iif file.

    >Unfortunately,
    >> >my version of
    >> >> Excel (Office 2000) does not offer that extension when saving a file.

    >Can
    >> >someone tell me
    >> >> how to create an *.iif file from Excel.
    >> >>
    >> >> Thanks
    >> >>
    >> >> John Baker
    >> >

    >>

    >
     
    John Baker, Aug 7, 2004
    #6
  7. John Baker

    Karl Irvin Guest

    Why not just have Access write the IIF file?


    "John Baker" <> wrote in message
    news:...
    > Gary:
    >
    > Thanks.. that points me in he right direction.
    >
    > . Out of Access, I will create a file .xls format containing the

    appropriate data.
    > . I will program have an .xls spreadsheet which will contain macros which

    will
    > . open an .iif file the appropriate name
    > . clear out the current contents
    > . copy the Access produced xls data into the iif file
    > . and then save it.
    >
    > I think that will work.
    >
    > best
    >
    > John
    >
    > "Gary" <> wrote:
    >
    > >John,
    > >
    > >Sorry I don't know of any process that does this automatically. However

    if a
    > >person opens an existing IIF file, Excel will import. Then you can click
    > >save and it will retain the name. I also suppose one could create a macro
    > >(or via code) to assist the user.
    > >
    > >Gary
    > >
    > >"John Baker" <> wrote in message
    > >news:...
    > >> Gary:
    > >>
    > >> Do you know of any piece of software that will do this automatically? I

    > >have an
    > >> unsophisticated user who will mess up the process of changing the

    > >extension.
    > >>
    > >> Best
    > >>
    > >> John
    > >>
    > >> "Gary" <> wrote:
    > >>
    > >> >Hey John,
    > >> >
    > >> >Do save from Excel, just choose Text (tab delimited) as your option to

    > >save
    > >> >as. After you have saved, use explorer to locate the folder and the

    file,
    > >> >right click on the file and change the name from .txt to .iif. It may

    be
    > >> >easier to do if you have unchecked the box under explorer that says

    hide
    > >> >extensions of known file types.
    > >> >
    > >> >Another way is to choose Text (tab delimited) as your save as type

    while
    > >in
    > >> >Excel, in the file name dialog box put the filename in quotes such as
    > >> >"payroll.iif", it will then save that name as a delimited file.
    > >> >
    > >> >cheers
    > >> >gary
    > >> >
    > >> >"John Baker" <> wrote in message
    > >> >news:...
    > >> >> Hi:
    > >> >>
    > >> >> I just started exploring how to import Payroll and Invoice data into
    > >> >Quickbooks, and see
    > >> >> that you can import from Excel by creat8ing a *.iif file.

    > >Unfortunately,
    > >> >my version of
    > >> >> Excel (Office 2000) does not offer that extension when saving a

    file.
    > >Can
    > >> >someone tell me
    > >> >> how to create an *.iif file from Excel.
    > >> >>
    > >> >> Thanks
    > >> >>
    > >> >> John Baker
    > >> >
    > >>

    > >

    >
     
    Karl Irvin, Aug 7, 2004
    #7
  8. You would be better off studying the
    free QuickBooks SDK interface at
    http://www.developer.intuit.com/

    It is only a matter of time before Intuit
    leaves IIF out of QuickBooks. To the
    contrary, they actively support the SDK
    with free forums and recently said QB
    & SDK upgrades would not make QB
    add-ons stop working.

    Mike Block, C.P.A.
    Intuit paid me to make QuickBooks better!
    http://www.blocktax.com/
    http://www.quickbooks-add-ons.com/


    "John Baker" <> wrote in message
    news:...
    > Hi:
    >
    > I just started exploring how to import Payroll and Invoice data into

    Quickbooks, and see
    > that you can import from Excel by creat8ing a *.iif file. Unfortunately,

    my version of
    > Excel (Office 2000) does not offer that extension when saving a file. Can

    someone tell me
    > how to create an *.iif file from Excel.
    >
    > Thanks
    >
    > John Baker
     
    Mike Block - Tax Cut C.P.A., Aug 8, 2004
    #8
  9. John Baker

    John Baker Guest

    Karl

    I have Access 2000, and it does not appear to permit the creation of .iif files as far as
    I can see.

    Are you aware of any methings I could use (besides crteating an xls file and changing the
    extension) to creat an iif from Access?

    Best

    John

    "Karl Irvin" <> wrote:

    >Why not just have Access write the IIF file?
    >
    >
    >"John Baker" <> wrote in message
    >news:...
    >> Gary:
    >>
    >> Thanks.. that points me in he right direction.
    >>
    >> . Out of Access, I will create a file .xls format containing the

    >appropriate data.
    >> . I will program have an .xls spreadsheet which will contain macros which

    >will
    >> . open an .iif file the appropriate name
    >> . clear out the current contents
    >> . copy the Access produced xls data into the iif file
    >> . and then save it.
    >>
    >> I think that will work.
    >>
    >> best
    >>
    >> John
    >>
    >> "Gary" <> wrote:
    >>
    >> >John,
    >> >
    >> >Sorry I don't know of any process that does this automatically. However

    >if a
    >> >person opens an existing IIF file, Excel will import. Then you can click
    >> >save and it will retain the name. I also suppose one could create a macro
    >> >(or via code) to assist the user.
    >> >
    >> >Gary
    >> >
    >> >"John Baker" <> wrote in message
    >> >news:...
    >> >> Gary:
    >> >>
    >> >> Do you know of any piece of software that will do this automatically? I
    >> >have an
    >> >> unsophisticated user who will mess up the process of changing the
    >> >extension.
    >> >>
    >> >> Best
    >> >>
    >> >> John
    >> >>
    >> >> "Gary" <> wrote:
    >> >>
    >> >> >Hey John,
    >> >> >
    >> >> >Do save from Excel, just choose Text (tab delimited) as your option to
    >> >save
    >> >> >as. After you have saved, use explorer to locate the folder and the

    >file,
    >> >> >right click on the file and change the name from .txt to .iif. It may

    >be
    >> >> >easier to do if you have unchecked the box under explorer that says

    >hide
    >> >> >extensions of known file types.
    >> >> >
    >> >> >Another way is to choose Text (tab delimited) as your save as type

    >while
    >> >in
    >> >> >Excel, in the file name dialog box put the filename in quotes such as
    >> >> >"payroll.iif", it will then save that name as a delimited file.
    >> >> >
    >> >> >cheers
    >> >> >gary
    >> >> >
    >> >> >"John Baker" <> wrote in message
    >> >> >news:...
    >> >> >> Hi:
    >> >> >>
    >> >> >> I just started exploring how to import Payroll and Invoice data into
    >> >> >Quickbooks, and see
    >> >> >> that you can import from Excel by creat8ing a *.iif file.
    >> >Unfortunately,
    >> >> >my version of
    >> >> >> Excel (Office 2000) does not offer that extension when saving a

    >file.
    >> >Can
    >> >> >someone tell me
    >> >> >> how to create an *.iif file from Excel.
    >> >> >>
    >> >> >> Thanks
    >> >> >>
    >> >> >> John Baker
    >> >> >
    >> >>
    >> >

    >>

    >
     
    John Baker, Aug 8, 2004
    #9
  10. John Baker

    Karl Irvin Guest

    IIF files can be either comma separted (csv) or tab delimited files. The IIF
    denotes a specific layout required by QuickBooks. Use the Access "Write"
    statement to create a csv file with IIF fomatted data in it. You can give
    the file an iif extension.



    "John Baker" <> wrote in message
    news:...
    > Karl
    >
    > I have Access 2000, and it does not appear to permit the creation of .iif

    files as far as
    > I can see.
    >
    > Are you aware of any methings I could use (besides crteating an xls file

    and changing the
    > extension) to creat an iif from Access?
    >
    > Best
    >
    > John
    >
    > "Karl Irvin" <> wrote:
    >
    > >Why not just have Access write the IIF file?
    > >
    > >
    > >"John Baker" <> wrote in message
    > >news:...
    > >> Gary:
    > >>
    > >> Thanks.. that points me in he right direction.
    > >>
    > >> . Out of Access, I will create a file .xls format containing the

    > >appropriate data.
    > >> . I will program have an .xls spreadsheet which will contain macros

    which
    > >will
    > >> . open an .iif file the appropriate name
    > >> . clear out the current contents
    > >> . copy the Access produced xls data into the iif file
    > >> . and then save it.
    > >>
    > >> I think that will work.
    > >>
    > >> best
    > >>
    > >> John
    > >>
    > >> "Gary" <> wrote:
    > >>
    > >> >John,
    > >> >
    > >> >Sorry I don't know of any process that does this automatically.

    However
    > >if a
    > >> >person opens an existing IIF file, Excel will import. Then you can

    click
    > >> >save and it will retain the name. I also suppose one could create a

    macro
    > >> >(or via code) to assist the user.
    > >> >
    > >> >Gary
    > >> >
    > >> >"John Baker" <> wrote in message
    > >> >news:...
    > >> >> Gary:
    > >> >>
    > >> >> Do you know of any piece of software that will do this

    automatically? I
    > >> >have an
    > >> >> unsophisticated user who will mess up the process of changing the
    > >> >extension.
    > >> >>
    > >> >> Best
    > >> >>
    > >> >> John
    > >> >>
    > >> >> "Gary" <> wrote:
    > >> >>
    > >> >> >Hey John,
    > >> >> >
    > >> >> >Do save from Excel, just choose Text (tab delimited) as your option

    to
    > >> >save
    > >> >> >as. After you have saved, use explorer to locate the folder and the

    > >file,
    > >> >> >right click on the file and change the name from .txt to .iif. It

    may
    > >be
    > >> >> >easier to do if you have unchecked the box under explorer that says

    > >hide
    > >> >> >extensions of known file types.
    > >> >> >
    > >> >> >Another way is to choose Text (tab delimited) as your save as type

    > >while
    > >> >in
    > >> >> >Excel, in the file name dialog box put the filename in quotes such

    as
    > >> >> >"payroll.iif", it will then save that name as a delimited file.
    > >> >> >
    > >> >> >cheers
    > >> >> >gary
    > >> >> >
    > >> >> >"John Baker" <> wrote in message
    > >> >> >news:...
    > >> >> >> Hi:
    > >> >> >>
    > >> >> >> I just started exploring how to import Payroll and Invoice data

    into
    > >> >> >Quickbooks, and see
    > >> >> >> that you can import from Excel by creat8ing a *.iif file.
    > >> >Unfortunately,
    > >> >> >my version of
    > >> >> >> Excel (Office 2000) does not offer that extension when saving a

    > >file.
    > >> >Can
    > >> >> >someone tell me
    > >> >> >> how to create an *.iif file from Excel.
    > >> >> >>
    > >> >> >> Thanks
    > >> >> >>
    > >> >> >> John Baker
    > >> >> >
    > >> >>
    > >> >
    > >>

    > >

    >
     
    Karl Irvin, Aug 8, 2004
    #10
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Vilasack Phothisan

    QuickBooks Time Activity IIF Import Sample File

    Vilasack Phothisan, Jun 8, 2004, in forum: Accounting Software
    Replies:
    0
    Views:
    761
    Vilasack Phothisan
    Jun 8, 2004
  2. Bill Fears
    Replies:
    1
    Views:
    350
    Bill Fears
    Sep 24, 2003
  3. For example John Smith

    IIF File Help PLease

    For example John Smith, Oct 29, 2003, in forum: Quickbooks
    Replies:
    1
    Views:
    272
  4. Karen

    IIf File Import for Payments

    Karen, Nov 25, 2003, in forum: Quickbooks
    Replies:
    9
    Views:
    1,064
    Karen
    Nov 27, 2003
  5. John Derr
    Replies:
    3
    Views:
    539
Loading...

Share This Page