Insert values to an access database
I am trying to read 1000 line items from a file and put them into a Access
Database. Each line item is a seperate column. whats the best way to do this?
The way I know to insert a record to a table is by using
INSERT INTO PersonData2 VALUES (value1, value2, value3)
If I use that I a think I have to declare 1000 variables.
Is there a better way to do this. Please let me know if there is one.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL