Hello
I am writing coordinates to a .mdb file from an ascii text file using vba inside of AutoCad. My code looks like this:
Set dbsObj = DBEngine.Workspaces(0).OpenDatabase("c:\JHL1\temp. mdb")
Set rstObj = dbsObj.OpenRecordset("tblcoorsJHL2", dbOpenTable)
Do
.
.
.
rstObj.AddNew
rstObj!yxdata = Val(ya$) * 100
rstObj!xxdata = Val(xa$) * 100
rstObj!zxdata = Val(za$) * 100
rstObj.Update
.
.
.
Loop Until TheEnd
Access 2003 is installed on my computer. The numbers are stored as long integers. The db file is indexed on the key and y and x fields. This code works ok, but I'd like to know if it is possible to make it go faster. I have to deal with a large number of points (in the millions). In another part of the code I retrieve a smaller number of points (in the thousands) by using a SQL statement.
Thank you all
John