Hello community,
this is my first post in this forum since I had trouble finding an answer to my question on the internet/this forum.
A short outline of our situation:
We have approx. 700 files in the .qvd format that we want to combine and analyze with Stata (warehouse data). Each of those files has approx. 138k rows in Excel which makes it hard to combine them into one Excel file that we then import to Stata. I tried feeding Stata with an Excel that contained 10 combined qvd files (of the 700) which turned out to be already over the 40mb limit.
Is there any way we can directly import qvd/qvw files into stata? Or a different way that enables us to gather all the data in Stata?
Any help would be much appreciated!
Cheers
this is my first post in this forum since I had trouble finding an answer to my question on the internet/this forum.
A short outline of our situation:
We have approx. 700 files in the .qvd format that we want to combine and analyze with Stata (warehouse data). Each of those files has approx. 138k rows in Excel which makes it hard to combine them into one Excel file that we then import to Stata. I tried feeding Stata with an Excel that contained 10 combined qvd files (of the 700) which turned out to be already over the 40mb limit.
Is there any way we can directly import qvd/qvw files into stata? Or a different way that enables us to gather all the data in Stata?
Any help would be much appreciated!
Cheers
