Questions on Importing

Hi Brian,
We have a spreadsheet that is generated monthly by HR and is dumped into a shared folder in .xlsx format. Unfortunately the top 2 rows of the .xlsx file is used as a header which is throwing IDEA when I try to import the file.
My first guess is to have Excel grab the file open it, remove the rows and re-save the file then import with IDEA. Second is to use Excel to convert the .xlsx file to a .txt and import (ignoring the first few lines).

Using "advanced" to enter SQL for ODBC connections, Is it possible to declare SQL variable?
I.e   (Declare @table TABLE (*fields*);        *code to populate table*;           select * from @table     )
Pulling my data through first, then manipulating it isn't viable in this case

I have a text file, which I have imported through report reader.
There is a template set up to recognise the columns.
I have 12 monthly sales reports.
How can I import, apply template and merge results into one database?
 
The multiple import function built into idea only allows files of the same type to be imported.
Due to a two step process (taking text file and converting to pdf), I cannot do a multiple file import.
 
What are the shortcuts I can apply (if any)?

 Hi,
I am trying to import some text in Polish.Idea does not recognize Polish character.
I have added some font in polish  in my os (windows 7) without any result.
Do you know a way that it could allow IDEA to detect polish language ?
Thank you for your help.
Kind regards,
Mourad
 

I am importing an Excel file, but some of the cells from the original spreadsheet are coming up as blank in IDEA after the import.  It happens in various fields for various records with no apparent rhyme or reason.  Do you know why this might occur?  We are on version 8.  Thanks.
 

I'm looking to import files of HL7 messages. HL7 is a heirarchical message format specific to healthcare. Has anyone flattend a hl7 file, or know of any tools to flatten them prior to import? Or any generaladvice for flattening a heirichacal dat file in general...as you can see, i need your help!  :)
hl7  on wikipedia for the curious:  https://en.wikipedia.org/wiki/Health_Level_7
 
Rob

Hi Brian,
I am new in this Forum. It is very helpfull, thank You!
I have got some experience using ACL and IDEA Script. For automatic IDEA import purposes (eg. plain text- or delimited files) I often use RDFCREATOR functions. Unfortunately there are only few information about the procedures into the  RDFCREATORLIB. Do you know, if it is possible to get a better or complete documentation?
kind regards
Roger
 
  

Hello everybody,
it is actually the first time that I use IDEA for programming. Brian, I have had a look at your script which allows to import multiple Excel files from one folder into IDEA. Unfortuately, I could not solve my problem.
I recorded a macro in IDEA allowing to import just a single Excel file.

I tried running my data query in excel and in idea.Neither are correct - Any thoughts on what I am seeing. I was hoping with only 4 fields that either Idea or Excel could import the data correctly, but no luck.Thanks!
Excel
Comment = text   = correct
Comment id = column is missing = wrong
Created by = alphanumeric = correct
Reg note id = column is missing = wrong
 
Idea
Comment = numeric (character) = wrong
Comment ID = hexadecimal (character)= wrong
Created by = alphanumeric (character)= correct

Every month I have a file that is automatically generated by another department and saved to a shared drive as an .xlsx file. The problem is the top few lines of the file are loginfo such as file title, ID, run time etc., but causes an issue with importing into IDEA since the first row is not the data header row. More specifically, the header starts on row 4, with information on rows 5+