472,133 Members | 1,169 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,133 software developers and data experts.

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 1685
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.