Hi,
I've been having terrible trouble with this for some time so I really hope you can help me.
The problem is that I have imported some Excel files in delimited text format using the Import ASCII facility. I have only 2/3 of the information I need in an OI table as although I treated all three excel files in the same way (as they were all part of the same timetable) I get this message on the third one which tells me there are 'no files to import'. This is a mystery.
I have the feilds set up in the corresponding part of Table Builder but I don't know what to do next. I need to be able to query the tables and put in hyperlinks when the results come up. At the moment nothing happens at all. A further problem is the excel files are in czech. I have changed their feild headings in excel to english so they match those in Table Builder before importing them but this could possibly be causing a problem.
Please help as I'm at my wits end.
Cheers,
Ben Robinson
Brno, Czech Republic
Ben,
All things being equal .. things should be working. But as we all know things are very seldom equal.
Have you tried importing the 3rd batch into a different table? Does that work?
[email protected] onmouseover=window.status=imagine … ;return(true)"
David Tod Sigafoos ~ SigSolutions
Cell: 503-341-2983
Perhaps I am missing something here because I have just started in OI and have lots to learn, but… Since Excell is ODBC then why wouldn't you use OI's DDE facility in Client/Server to establish connectivity between OI and your excell files, rather than the ASCII import approach? It seems to me it would be more efficient and perhaps less prone to errors. Of course however, I have never tried this so who knows?
Hello Again,
Supposing I get the information imported successfully, what do I do after I have the feilds set up in table builder? How do I link them together and then what do I do?
Ben.
I do not understand, what do you want to do, but
if the problem is with czech language in OI, then we
have some experience in implementing this.
R.Spiegel, Cosmotron Systems, Czech Rep.