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

Sample Book Database or CSV List

P: n/a
Hi,

I am currently developing an access database for books which contains
ISBN,author,title info etc...
I am trying to find an online book library or database that would allow me
to search for a particular
subject and export the results to csv for importing into my database. The
list needs to be detailed
and contain ISBN, author,year,publisher etc...

This is so I can test my database with real records. I've searched
universities, bookshops and
amazon etc...but none of these seem to have any facilities for exporting
your searches to csv
or tab-seperated lists.

If anyone here can give me some links or offer advice on how i can import
real sample data into my book
database, you would relieve me alot of cutting and pasting from HTML web
search pages.

Thanks....
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ho boy. so put in *fake* ones! You gotta be kidding! Search the
public library for records and copy and paste. get real, will ya?

Oh sure, write a parser using ADO or something. Or Perl or awk or
grep... and once your data is nice and clean, import into Access...

Nov 13 '05 #2

P: n/a
so your reply is simply....no, there are no websites that offer search
results in csv format ??

I do not want to use fake data because it is so easy to input similar data,
not enough randomness
to it. If i could obtain say 150 records of real data then I can be sure
that this data is in the exact form
and random nature I would expect in a real world scenario.

Sure I could use some perl script to extract HTML search data, but this is
too much work and does not
contain all the fields required. A simple exported csv list from a book
catalogue would suffice.

BTW...i'm not looking to steal the world's library records of books and
authors !!!!
"Carl" <no****@dsaljdsalk.com> wrote in message
news:zV**************@newsfe5-win.ntli.net...
Hi,

I am currently developing an access database for books which contains
ISBN,author,title info etc...
I am trying to find an online book library or database that would allow me
to search for a particular
subject and export the results to csv for importing into my database. The
list needs to be detailed
and contain ISBN, author,year,publisher etc...

This is so I can test my database with real records. I've searched
universities, bookshops and
amazon etc...but none of these seem to have any facilities for exporting
your searches to csv
or tab-seperated lists.

If anyone here can give me some links or offer advice on how i can import
real sample data into my book
database, you would relieve me alot of cutting and pasting from HTML web
search pages.

Thanks....

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.