SQL statements ina text file

[Guest]

Greetings All,

I have a text file that contains many sql strings that I wish to use to load
into a database.

Example of text file

INSERT INTO `tableTbl` VALUES (1,2,341,5,'a',6,'b',7,'c',8);INSERT INTO
`tableTbl` VALUES (11,12,13,14,15,'a',16,'b',17,'c',18);

Many thanks All

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SQLLoader.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L