Hi
My ISP gives me phpMyAdmin to get in contact with my MySQL-db
but sadly enough the "IMPORT TEXTFILE TO TABLE" do not work
(gives errormessage "#1045 access denied" and I do not know if it will be fixed,
everything else seems to work allright)
so I'm looking for an other (easy) way to upload 3000 + more records.
--
Erik RN
Denmark 2 1895
erik wrote: Hi My ISP gives me phpMyAdmin to get in contact with my MySQL-db but sadly enough the "IMPORT TEXTFILE TO TABLE" do not work (gives errormessage "#1045 access denied" and I do not know if it will be fixed, everything else seems to work allright) so I'm looking for an other (easy) way to upload 3000 + more records.
If your ISP has PHP I'd just write a load.php script. Not knowing what
your data looks like (1 col... 10 cols) hard to say. Anyway if you dont
have PHP theres bash. Do a script that outputs:
"insert into mytable values ("v1", "v2", n1, n2);"
then run the script:myscript > load.sql mysql mydb < load.sql
even in PHP you'd need a line $insq = "inser.... ("$val1", "$val2",...
cal
erik wrote: Hi My ISP gives me phpMyAdmin to get in contact with my MySQL-db but sadly enough the "IMPORT TEXTFILE TO TABLE" do not work (gives errormessage "#1045 access denied" and I do not know if it will be fixed, everything else seems to work allright) so I'm looking for an other (easy) way to upload 3000 + more records.
If your ISP has PHP I'd just write a load.php script. Not knowing what
your data looks like (1 col... 10 cols) hard to say. Anyway if you dont
have PHP theres bash. Do a script that outputs:
"insert into mytable values ("v1", "v2", n1, n2);"
then run the script:myscript > load.sql mysql mydb < load.sql
even in PHP you'd need a line $insq = "inser.... ("$val1", "$val2",...
cal This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jeffrey Silverman |
last post by:
Hi, all. Sorry, first off, for the kidna weird selection of crossposted
groups, but this question touches on aspects of discussion in each of the
groups.
So I have a group of around 500 email...
|
by: John Rauhe |
last post by:
Hello,
Does anybody know how to detect if an mass-storage device has been added to
the system ? I am making a program that will (should) detect when a
CompactFlash memory card has been inserted...
|
by: kartik |
last post by:
Hi ,
I am in need to find a way, to mass copy the data from db2 table
running in mainframe to universal database db2 on NT. I know that DB2
connect gives the flexiblity of connecting and...
|
by: Strasser |
last post by:
In Access2000 mass emailing worked perfectly (very powerful tool!).
Doesn't work when using XP version of both Access and Outlook, even
though I checked the box to ensure that I was sending the...
|
by: Ivan |
last post by:
Hi, all,
How to get BusRelations of a USB Mass Storage Device in C#?
Or, do we have any function to get BusRelations of a USB Mass Storage
Device, even not in C#?
Any information is...
|
by: Gil \(Asp.net Developer\) |
last post by:
|
by: Vjay77 |
last post by:
As a result from who is I am getting this:
>
> NOTICE AND TERMS OF USE: You are not authorized to access or query
our WHOIS database through the use of high-volume, automated,
electronic...
|
by: colleen1980 |
last post by:
Hi:
Can any one please help me when user select 2 dates from DDLDate1
10/09/2006 and DDLDate2 10/12/06 and the name and it close the form. I
need to create multiple records in the another table on...
|
by: teo |
last post by:
Hallo,
I'm performing a mass insertion
from a text file to a db table
with AdoNet commands, like this:
myCommand.CommandText = "BULK INSERT ..."
from a Win form
no problem
|
by: wrldruler |
last post by:
Hello,
First, I know it's against "Access Law" to save calculations in a
table, but....I want/need to.
I currently have sub-totals being calculated inside a form, using
DMax, DCount, and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
| |