469,159 Members | 1,502 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

Excel 2000 - application.ImportXML (file over 65000)


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
Jun 23 '08 #1
1 1614
1,295 Expert 1GB

you can use the FORMAT function inside a loop

Expand|Select|Wrap|Line Numbers
  1. for i = 1 to 90000
  2. expression = format(expression, format)
  3. next
or, chop your XML in 65000 tables, and import each one into a different sheet, then merge them

Jun 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

21 posts views Thread by bobh | last post: by
14 posts views Thread by cj | last post: by
4 posts views Thread by =?Utf-8?B?THluZXJz?= | last post: by
4 posts views Thread by hangar18 | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.