By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,375 Members | 3,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,375 IT Pros & Developers. It's quick & easy.

Excel 2000 - application.ImportXML (file over 65000)

P: 93
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
Jun 23 '08 #1
Share this Question
Share on Google+
1 Reply


kadghar
Expert 100+
P: 1,295
sure,

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

HTH
Jun 23 '08 #2

Post your reply

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