In Answer to steve:

Routing using UK OS (eithier OSCAR or Intergrated Transport Layer) road data.

As to samples I would probably have to roll my own so I'm not suire...

Well whats the answer then?

Depeneding in the size of the input the first, the second gets slower and slower compared to the first as the number of items in the WHERE gets bigger (on...

2 X Desktops Running XP

1 X Laptop Running XP

1 X Desktop Running 2000 Pro

1 X Desktop Running 2000 Server

1 X UK Tivo Running whatever funny flavour of linux that Tivo's...

I was acutaly trying to find a way of avoiding adding smileys as I noticed some code posted where it seemed to have automaticaly added them

OK I've found how to do it:

Setup and ODBC DSN using the text driver pointing the directory containing the file you can then use the DTS wizard and each file...

Can you remember which DB format it was, I've only got .CSV, SuperTable and SASPAC?

I can obviously import individual .CSV's fine but can't find a way to bulk import them!

NOTE:

The tables don't exist in SQL server they will need to be created by the script using a combination of file name (ST008DATAAF1.CSV vs. ST008DATAbF1.CSV, etc.) and the number of...

Sorry I've not been updating this thread but I've had 101 other thigns getting in the way:

Anyway current plan is:

Convert the list in WDDX (XML).

Then eithier: INSERT this into...

quote:

---

I'm not sure where you are getting your list of postcodes from but could you not use DTS to import the list...

quote:

---

IN should only be used for short lists. It is not very efficient. Put the list of postcodes into a table and...

quote:

---

elvistheprince,

I also saw that for some reason SQL became extremely slow when given the large number of values in the IN clause.

I'd...

quote:

---

I noticed that you are sending in the query as a dynamic SQL. It would be better to bite the bullet...

quote:

---

(1) Is the Access database and SQL Server on the same system?

(2) Are you accessing them in the same way (say across...