If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Convert XLS to IIF anyone?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Dec 2004
Posts: 277
Convert XLS to IIF anyone?

Trying to convert an Excel file into an IIF, anyone know how this could be done easily?
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Dec 2003
Location: Dallas, TX
Posts: 998
Quote:
Originally Posted by DackJaniels
Trying to convert an Excel file into an IIF, anyone know how this could be done easily?
Hi DackJaniels,
What are you meaning about convert an Excel file into and IIF? XLS is the file format for Excel. IIF if an expression used for the ImmediateIf statement. The two are nothing of the same category. I think you're familiar with IF statements in Access? It gives you one of two arguments and I believe both are evaluated. IIF is said to be a shorter version of an If, Then, Else statement.

have a nice one,
BUD
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2004
Location: Aberdeen, Scotland
Posts: 1,067
Hi Bud

looking at DackJanials other posts i assume that IIF is the Quickbooks format?

the only way i can think of doing this is to put the files into a text file then import from there but having never used quickbooks thats just a guess
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Dec 2003
Location: Dallas, TX
Posts: 998
Quote:
Originally Posted by DavidCoutts
Hi Bud

looking at DackJanials other posts i assume that IIF is the Quickbooks format?

the only way i can think of doing this is to put the files into a text file then import from there but having never used quickbooks thats just a guess

Ooops....haha...wow. Live and learn. That's interesting as I have never heard of that as a format, but now I know...

thanks
BUD
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Mar 2005
Posts: 1
Convert XLS to IIF anyone?

An .iif file is a quickbooks file format. All you need to do once
you have the header lines in place and you can get several examples of how to do this from the quickbooks web site is to save the excel sheet as a csv file with a .iif extension
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 On
Pingbacks are On
Refbacks are On