Load Excel into MySQL
Thank you for taking the time to report an issue.
What's wrong... Please write below.
As a test, I was able to load the same 4 programs (Word, Excel, Powerpoint & Access) on a 32 bit, XP machine I no longer use. How can I determine why Access will not load on my win7 machine?
I understand that I need to use a query and I know (sort of) how to build an expression but I just don't know how to do this one.
So far I have | Epression1: StDev([Load 1] + [Load 2]+ [Load 3] + [load 4] + [Load 5] + [Load 6] + [Load 7] + [Load 8] + [Load 9] + [Load 10]). I know that the plus signs are wrongbut I'm not sure what to use.
I am running a trial version of Access 2010 which has been great so far.
does anyone know where I can get a list of all connectivity methods for Access and MySql? the MYSQL documentation pages are not very helpful.
I have found out that on a Linux-based platform, DSN is not supported with MYSQL unless it is through coldfusion scripts. Now, what that means I have no idea. I know what cold fusion is, but I'm not sure how the 'scripting' part of that relates to a FILE DSN.
So what I have got from my hosting company is that there is more than one method to connect to a mysql server, and that I should use one of those if I want to use Access with mysql. does anyone have experience? More than that though, I need a resource of the different ODBC methods that are out there so I can figure out which one would be the best for an Access/Mysql partnership
1. The simplest solution would be to add entries directly into Access, but I need to be able to enter them wherever I want to, and I can only get it to add a new entry at the end I.e. I have 10 entries with Primary Key header ID with values 1-10.
I can add a new entry with number 11, but I need the ability to add a new row at say id 5, with all entries afterward changing id to accommodate.
2. Within each entry is a field that references the id of certain entries, I.e. entry 8 has a field linked to the id on entry 5. If I add an entry before number 5, the id number will change and I need entry 8 field to change with it. Again,
3. I can accomplish both of the above requirements in Excel, so I was trying to import it, but having problems there too! My ideal solution (barring that BOTH of the above can be done is Access) would be to have a table within Excel with the same name as the linked one in Access, and somehow have Access sync all 3 files (MySQL, Access, Excell), I.e.
if I add an entry in Excel then Access updates itself and MySQL (automatically or manually) and vis-a-versa.
how can I cut the info from Excel and paste it into a linked database? Currently when I try I either get an error along the lines of "pastedarea to small" (only dealing with 10 records as I am trying to work the dynamics out, will be hundreds down the road) or "NULL value can't be inserted (even though no fields are empty, theyall have either some text, numbers, or a 0 or 1, and some are actually the exact same as some records that are in the database, though I deleted the duplicates to see if that was the issue).
The problem I am having is that each time I load the form (it has other functions as well), it is taking a long time to load as I am assuming it is running the query.
How do I only run the query when I have a need to and not every time the form loads?
I already tried the simple approach with "X.picture = URL.jpg" but apparently Access cannot open jpgs following this procedure.
I have already searched a lot in forums etc., but I didn't find anything working yet. I don't want to save the logos on my disk since the application is used by several users.