Excel 2000 - application.ImportXML (file over 65000)

[emsik1001]

Hi

I need to upload XML into SQL Server 2000 and excel seems to be a very good place to get the data in the correct format; however the file is more then 65000 rows how.

What are other options to do it?

(Currently the code goes every single text file line to get the data which is 40-50mins)


Many thanks in advance

[kadghar]

sure,

you can use the FORMAT function inside a loop

for i = 1 to 90000
expression = format(expression, format)
next

or, chop your XML in 65000 tables, and import each one into a different sheet, then merge them

HTH