Hi Dmitry. We had such effects when we used copied and modified templates. POI was bringing an "unknown Ptg 3D warning" and Excel made problems. Building the templates from the scratch led to proper results.
Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Dmitry Beransky [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. Mai 2004 01:56 An: [EMAIL PROTECTED] Betreff: problem importing POI generated xls into access Hi, I'm facing a strange problem, which, I suspect may stem from a obscure error somewhere in POI code. I'm generating excel files from a template. Pretty much just finding certain cells using named ranges, populating them with data from a database. Then these files are sent out to various people for approval and optional adjustments. When they come back, we import the data into an access database. One of the fields that's being output into the template and later imported into the database is a date stamp. The date looks right in excel, but Access gets really confused by something and imports the date as 1/0/1900. A temporary fix I've found so far is to open the template and resave it before importing into Access. Doing this somehow fixes the date issue. This is not really a good solution, as we have many files to process. Any thoughts? Here's a sample file exhibiting the problem: http://dembel.org/neur.xls. Try importing the "Upload" sheet into Access and look at the column named "Period" Thanks Dmitry --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
