Sql commandod and ms access

[stigejg]

Hi out there,

I have a question for the right one.

I have a Access-database ond wishes to update data there helpt by other SQL-tools.

I have tested with some luck. I managed to insert data if I executed line by line in my sql-script. Like this:

INSERT INTO tablename VALUES ('27.04.2001', 'SOER', '33014', '01.05.2001', 500, 4.35);

But when i have to execute line by line it will take too much time.

So the big question is---> are there some ways that i can insert data into a table like i can i oracle SQL* plus by copy from notepad and paste int the sql-buffer? I have round 200 records i want to insert into various tables twice a month.

SQL-script looks like this:
INSERT INTO tablename VALUES ('27.04.2001', 'SØR', '33014', '01.05.2001', 500, 4.35);
INSERT INTO tablename VALUES ('27.04.2001', 'SØR', '33024', '01.05.2001', 1000, 5.25);
INSERT INTO tablename VALUES ('27.04.2001', 'SØR', '33037', '01.05.2001', 2500, 5.15);

Is it posible to use SQL from Access to this job or are there other tools i may can use to this job?

regard Stig

 

[THoey]

Did you look at Import (File -> Get External Data -> Import)? If you have this in a text file, you could create an import specification and do this rather quickly. Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.