There is only ONE table that will never import and I don't understand why it's just this one table. I get the error: "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed...
Also, I need to calculate the age of a person and I use =datedif(xx,xx,"y"). But, again,. the calculation won't work for any date prior to 1900. Hello!
The biggest strength you need in Excel is troubleshooting. There are many reasons a formula won’t work, identifying what is going wrong makes it simple to correct. One of the tasks I did everyday was importing data into Excel. This causes problems as the imported text often behaves differen...
In the above code, note that the italicized “filepath” references the full path of the workbook. Without the appropriate Workbooks.Open filename, you won’t be able to open the given file. You will also need the appropriate file type (Microsoft Excel, which is either XLS or XLSX) or ...
Thanks for the bug report Jennifer, we will take a look to it. Happy Holidays! === Javier Treviño MySQL on Windows Team Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of...
Judging by the description of the problem I would say that table you can't import is very big or for some other reason it exceeds the default time set for a query execution. If you are using the latest version you will see there is an "Options" button in the Welcome Panel (the pan...
I have several tables importing successfully that are much bigger than this table, which currently only has 191 rows and 18 fields. So I'm pretty sure it's a different problem. I will read the instructions on posting a bug and will do this soon....