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. 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.

QuickBooks Import from Excel and CSV. Successfully import Excel and CSV files into QuickBooks. IIF is a tab delimited import text file. Construction Project Management By Chitkara Pdf Viewer there.

>>>>Thanks >>>>John Baker. 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, 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: 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 >>>>>. 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 >>>>>>>>>. You would be better off studying the free QuickBooks SDK interface at 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. Compressor Aerodynamics Cumpsty Pdf Viewer.

Mike Block, C.P.A. Intuit paid me to make QuickBooks better! '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 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 >>>>>>>>>>>>>>. 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 >>>>>>>>>>>>>>>>>>>>.