Wow didn't know this. Yeah I can open it on 7Zip.
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
Really appreciate your help but the excel file came from our client so I cannot put it in any site as a sample. What do you mean by run it on a validator?
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
Ok so I have a spreadsheet which has a .xlsx extension and downloaded this on a FTP site. As I search in the internet you need to use this connection string for .xlsx files using ADODB.
conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & path & ";Extended Properties=Excel 12.0;"
But this gives error on conn.Open, this is the error External table is not in the expected format.. When I manually open the spreadsheet on MS Office Excel then save it, I can successfully connect to said spreadsheet. Note: On my machine I have office installed but on the machines where my program will be deployed don't so I need to use ADODB to read the contents.
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
I download the file first from FTP to local files then connect locally. I tried this
conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & path & ";Extended Properties=Excel 12.0;"
but still got the error. When I open the file and saved locally then retry to use the above connection string, I can now connect.
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
Hello Everyone, Can you please advice on why I cant connect to excel file without saving it on my machine. I tried using these to connection string but still got an error External table is not in the expected format.
conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & path & ";Extended Properties=Excel 12.0;"
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path & ";Extended Properties=Excel 8.0;"
When I try to open and save as the spreadsheet I can successfully connect. The file is on FTP and will be downloaded by automation and get information. I cannot make it automatic if I need to open the excel file and save it. The terminal I will deploy the program dont have office installed so I need to use a different tool to get data. Any suggestion appreciated thanks in advance.
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
Why is that the Mapped Drives is not listed on this method? It can read Flash Drives. I am using Windows 10, is this the factor? I tried opening a JFileChooser and mapped drives is also not found. I also try using the file exist
System.out.println(new File("Z:\\test.txt").exists()); //returns false
System.out.println(new File("\\\\192.168.23.111\\Shared Files\\test.txt").exists()); //returns true
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
Is socket fast? Process we have is just simple data lock. A main database which contains 10,000 - 20,000 records (created daily if MDB used) that will access the server. There will be 100+ clients that will request what data they will access/process then send the keyed data to server and the server will save that record. Socket is a very nice way to do this but I don't know if it can handle massive request. Server is only 8G RAM with I3 processor.
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
What is best to use. Mostly I use METHOD POST for this action (Add, Update, Delete) In User Module. 1. Create Servlet for each Action (Login, Create, Update, Delete) OR 2. In JSP for each FORM create a input hidden which contains the process (Login, Create, Update, Delete) and Create one Servlet that read this hidden input and process specific action.
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
thank you very much it works :zzz:
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
well that gives me an idea.. casting should do the trick Thanks
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
Why is it giving me a zero.
double percent = 0;
if(condition) {
//scrollpane is a JScrollPane and origIcon is a ImageIcon
percent = scrollpane.getHeight() / origIcon.getImage().getHeight(scrollpane);
System.out.print(scrollpane.getHeight() + " / " + origIcon.getImage().getHeight(scrollpane));
System.out.println(" = " + percent);
} else {
//line of codes
}
This returns 309 / 1668 = 0.0 value should be 0.1852.. I know this is basic but I DON'T KNOW. sorry, too tired I guess but I need this to figure out Thanks
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting.
Hello Experts, I have a table ID, Lock and other fields. I have a VB.NET program that gets the TOP 1 record that is not lock and lock that record to be keyed/entry. Multiple users will use this program, is it possible that more than one user can access the same record in this process? Its possible users will request a record at the same time. Thanks a lot. Revision Table ID | Lock | ------------ 1 | False | 2 | False | 3 | False | Lets say that 2 computer are using same program connecting to the same server database Client:1 - Request Time: 10:30:00 will get the ID 1, ID 1 will lock(update to true) Client:2 - Request Time: 10:30:05 will get the ID 2, ID 2 will lock(update to true) - cause ID 1 is lock This is my question. same request Client:1 & 2 - Request Time: 10:30:00 - Query is (SELECT TOP 1 * FROM Table WHERE Lock = False) - Put ID to a variable - In the above run time, Is the 2 client will get the ID 1 or the this query will stack on SQL Server will finish one query first before executing another query?
- Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. - Most of the problem in your life are due to two reasons: you act without thinking, or think without acting
yup, swap. okay thanks
Be who you are and say what you feel because those who mind don't matter and those who matter don't mind.
Another question... We have 4 licence and installed it in 4 terminal, we would like to reformat these 4. If we re-install it and we put the wrong product key, is Microsoft allow this?
Be who you are and say what you feel because those who mind don't matter and those who matter don't mind.
I don't know if this is a dumb question. Hope its not. If you have a 1 licence Microsoft Office 2013 and you reformat the computer is it okay to re-install the application.
that does't mean that I can't do it
Thanks for your answer. This is the Event Log when I open the application The application (Visual Studio 2005, from vendor Microsoft) has the following problem: Visual Studio 2005 has a known compatibility issue with this version of Windows. Fault bucket 38848502, type 17 Event Name: APPCRASH Response: Not available Don't know why this application showing error in compatibility. I can run this on the other day.
that does't mean that I can't do it
Sorry, should be in Visual Studio Forum really don't know what happened, I can use this application this past days I try searching it in google but can't find a solution
that does't mean that I can't do it
Hello everyone why is it that I can't run/open my Microsoft Visual Studio. When I open the Task Manager, at first devenv.exe will appear in process but it closes/ended in a moment. I tried using it in Safe Mode and the application is working. Please Help. Thanks
that does't mean that I can't do it
Hello everyone, 0xFFFF0000
btn.setBackgroundColor(0xFFFF0000);
I want to put that color in an array but don't know what datatype I will put to that
that does't mean that I can't do it
Is there a TimeZoneInfo in VB.NET 2005, all I can use is TimeZone.
that does't mean that I can't do it