eksekvere sql-fil i acces

If it is a file containing structured data then you may be able to import the data into Access. If it is a file with actual SQL statements then you will some how have to get the SQL into Access and the execute it. But without some more information its not easy to say what is possible!

any chance of seeing the file?

eksperten@NOSPAMsanthell.dk
remove NOSPAM

Hej igen, sql-filen ser således ud. Listen er selvfølgelig meget længere.

-------------------------------------------

CREATE TABLE polyphonic_ringtones_text (
  id int(5) unsigned NOT NULL auto_increment,
  title varchar(64) NOT NULL default '',
  author varchar(64) NOT NULL default '',
  hits int(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;


INSERT INTO polyphonic_ringtones_text VALUES (1,'What\'s Luv?','Ashanti',2);
INSERT INTO polyphonic_ringtones_text VALUES (2,'7 Days','Craig David',0);

------------------------------------------

the CREATE table SQL is not a valid Access format

If each SQL statement was valis, then it would still be necessary to read each SQL statement individually to execute it. So code will be necesary to do this.

Kan man ikke bare bare redigere filen således, at den virker? Fjerne Create Table, og så oprette tabellen selv og så fjerne alt "INSERT INTO polyphonic_ringtones_text ". Kan man ikke bare køre det i vb.net i asp.net?

Not quite sure what you mean by "...og så fjerne alt "INSERT INTO polyphonic_ringtones_text ""

If you did that  then the file would be empty :o)


You can run SQL in vb.net/asp.net but as far as I know, NOT directly from a text file containing the SQL. So you will either need to open the file and read the SQL into your program and run it from there. OR code the SQL statements directly in your code.

But without more information its hard to help.

If you create the table in Access then yu can cut and paste the INSERT into.... stataments (one at a time) into Access query designer and run them there

Det er over 3000 rækker....det er derfor jeg prøver andre metoder ;) Kan man ikke bare oprette en tabel i en database, og så kopiere dataene fra sql filen, altså:
----------------
INSERT INTO polyphonic_ringtones_text VALUES (1,'What\'s Luv?','Ashanti',2);
INSERT INTO polyphonic_ringtones_text VALUES (2,'7 Days','Craig David',0);

osv.
-------------------

og så køre dem i vb.net?

I do not think it is possible!

Hej igen! Har nu fået filen ind i databasen :)

Det er midi-filer som er gjort om til tekst-format

Fik nu et nyt problem! Hvordan får jeg midi-filerne at spille??

Not quite sure I understand that! what does a midi file have to do with a file containing plain SQL text?

If you do have a midid file somewhere, then it may be an idea to only save the path/filename to the file in the database. Then you can maybe use shellexec() to open the file using the files associated program.

http://www.mvps.org/access/api/api0018.htm

Hele filen er importeret i databasen. Jeg skal nu gøre det muligt hos brugeren at tage filen ud af databasen igen.

I need an answer to me comments 09/07-2005 10:06:34