Accountant Forums


Reply
Thread Tools

Creating an *.iif File from Excel

 
 
John Baker
Guest
Posts: n/a
Thanked:
 
      08-05-2004, 12:30 PM
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
 
Reply With Quote
 
 
 
 
Gary
Guest
Posts: n/a
Thanked:
 
      08-05-2004, 12:43 PM
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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



 
Reply With Quote
 
 
 
 
John Baker
Guest
Posts: n/a
Thanked:
 
      08-05-2004, 04:26 PM
Thank you...thats very helpful

Best

John

"Gary" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed).. .
>> 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

>


 
Reply With Quote
 
John Baker
Guest
Posts: n/a
Thanked:
 
      08-07-2004, 12:43 PM
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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed).. .
>> 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

>


 
Reply With Quote
 
Gary
Guest
Posts: n/a
Thanked:
 
      08-07-2004, 04:09 PM
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
> >news:(E-Mail Removed).. .
> >> 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

> >

>



 
Reply With Quote
 
John Baker
Guest
Posts: n/a
Thanked:
 
      08-07-2004, 05:17 PM
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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed).. .
>> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>> >news:(E-Mail Removed).. .
>> >> 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
>> >

>>

>


 
Reply With Quote
 
Karl Irvin
Guest
Posts: n/a
Thanked:
 
      08-07-2004, 06:45 PM
Why not just have Access write the IIF file?


"John Baker" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
> >news:(E-Mail Removed).. .
> >> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
> >> >news:(E-Mail Removed).. .
> >> >> 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
> >> >
> >>

> >

>



 
Reply With Quote
 
Mike Block - Tax Cut C.P.A.
Guest
Posts: n/a
Thanked:
 
      08-07-2004, 11:17 PM
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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



 
Reply With Quote
 
John Baker
Guest
Posts: n/a
Thanked:
 
      08-08-2004, 11:05 AM
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" <(E-Mail Removed)> wrote:

>Why not just have Access write the IIF file?
>
>
>"John Baker" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed).. .
>> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>> >news:(E-Mail Removed).. .
>> >> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>> >> >news:(E-Mail Removed).. .
>> >> >> 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
>> >> >
>> >>
>> >

>>

>


 
Reply With Quote
 
Karl Irvin
Guest
Posts: n/a
Thanked:
 
      08-08-2004, 05:54 PM
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote:
>
> >Why not just have Access write the IIF file?
> >
> >
> >"John Baker" <(E-Mail Removed)> wrote in message
> >news:(E-Mail Removed).. .
> >> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
> >> >news:(E-Mail Removed).. .
> >> >> 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" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
> >> >> >news:(E-Mail Removed).. .
> >> >> >> 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
> >> >> >
> >> >>
> >> >
> >>

> >

>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
export to excel not finding excel swcfm Microsoft Accounting 2 12-03-2008 11:00 AM
Quicken 2004 creating a Q3.DIR file on my desktop Rajesh Hingorani Quicken 2 12-06-2003 05:09 PM


All times are GMT. The time now is 11:23 PM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.