Sample Book Database or CSV List - Microsoft Access / VBA

Carl

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

Subscribe Reply

4785

pietlinden

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

Carl

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

Similar topics

5113

Mapping a datatable column to an xml element

by: Anita C | last post by:

Hi, How do I associate or map a specific column in a datatable to a particular element present in an xml document - to read into a datatable as well as write from the datatable to the xml element?...

.NET Framework

3134

Groff and Weinberg SQL Complete Reference - Sample database?

by: Paul Ganainm | last post by:

Not really a PostgreSQL question, but maybe somebody here knows the answer! I recently purchased Groff and Weinberg's The Complete Reference SQL, and a fine meaty tome it is too! However,...

PostgreSQL Database

7928

DB SAMPLE

by: Ale | last post by:

Ciao a tutti. Ho eliminato il database di esempio SAMPLE(non cancellato). Ora lo voglio reinstallare ma durante l'installazione mi da il seguente errore: nella finestra con scritto SQL1005N c'è...

DB2 Database

2527

Outlook Address Book

by: Phil Stanton | last post by:

Can anyone give me sone code to add addresses from a query to an Outlook Address book. The problem is that I want to add the new email addresses to a distribution list, not to the main email list ...

Microsoft Access / VBA

3640

SQL-DMO tutorial or sample code?

by: Andrew | last post by:

Hi Group! I'm looking for a tutorial in using SQL-DMO, or some sample code that will allow me to let my users switch the SQL Server database that the front end app is linking to as a back end. ...

Microsoft Access / VBA

1346

Getting sample code to work from a 'Wrox' book...

by: RAB | last post by:

Hello, I downloaded the VB samples from the 'Wrox book' website at the following address http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764558900,descCd-download_code.html I installed MSDE...

ASP.NET

2274

Does anybody have a real-world sample of building a treeview control

by: Henry | last post by:

Does anybody have a real-world sample of buiding a treeview control using data from database tables? All the sample code I have found either builds the treeview manually or uses a file directory...

C# / C Sharp

1494

Debugging book search application - assignment

by: momotaro | last post by:

You are to write a card catalog type definition. There are up to 1000 books, and for each one you need: Title A list of up to 5 authors Catalog number A list of up to 5 subject headings Status...

C / C++

2871

Error link to an Outlook Address Book from Access 2007

by: Lpitt56 | last post by:

I am running MS Access 2007 and I want to update an Outlook Address book from my Access Database. I started out by importing the Outlook Address Book as a linked table and it linked fine. I then...

Microsoft Access / VBA

7136

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7018

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7183

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7235

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6909

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

4923

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4614

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3108

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1431

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp