How can i download the table from patstat results
How can i download the table from patstat results
Good afternoon, how can I download a table with 100000 results?
-
- Posts: 425
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: How can i download the table from patstat results
Hello Waka,
In principle, you can not do such.
The downloads are limited in size (and dependant whether you have a subscription or the free trial)
see : patstat-online-download-and-extraction-limitations-9515
What you could do is split the download in multiple tables, at least if it is a reasonable amount.
Doing it for batches of queries will get your user_id blocked from the service.
Alternative: download a subset as ms ACCESS and then create the table in MS ACCESS. Subsets up to 100.000 applications can be created. But you have to be a bit modest in the amount of tables you select to stay under the 2 GB MS ACCESS size limits.
On the other hand, researchers seldom need such large datasets to conduct analysis.
In principle, you can not do such.
The downloads are limited in size (and dependant whether you have a subscription or the free trial)
see : patstat-online-download-and-extraction-limitations-9515
What you could do is split the download in multiple tables, at least if it is a reasonable amount.
Doing it for batches of queries will get your user_id blocked from the service.
Alternative: download a subset as ms ACCESS and then create the table in MS ACCESS. Subsets up to 100.000 applications can be created. But you have to be a bit modest in the amount of tables you select to stay under the 2 GB MS ACCESS size limits.
On the other hand, researchers seldom need such large datasets to conduct analysis.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org