Getting data out of a text file and putting it in an Access DB

[Laphan]

Hi All

First of all I want to thank you all for your time and patience this
weekend. Much appreciated.

Secondly, I'm stuck with the following:

1) Tab-delimited file consisting of 4 data columns (code, pic, productname,
price) with variable record size. File size ranges from 2KB to about 9KB.

2) Using ADO/ASP need to extract the data from this tab-delim file and
insert it into an Access table, which consists of 6 data columns (autoid,
code, pic, productname, price, category), which will also contain data from
previous imports.

For your ref, I've already put in place a query to delete all records where
category = xx, so that the insert basically re-inserts them all again. This
delete all and insert all method is OK.

3) When inserting this tab-delim data also want to add an integer value to
the 5th column (category) of this Access table, as this is data is part of
the import system not the tab-delim file.

Any ideas??

Many thanks.

Rgds

Laphan

[only me]

whilst I think it is possible to get ADO to treat a text file as a DB ( dont
know how to do it ,mind)
Since this sounds like the sort of this you would be running on an ad hoc
basis rather than a centeral pasrt of the day to day site op
I'd be tempted just to use a loop with FSO to read each line, 'split' it,
and build /exec each insert query based on the results of the split
Not as if your processing a massive amount of data

"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:bitit8$hho$1@titan.btinternet.com...

> Hi All
>
> First of all I want to thank you all for your time and patience this
> weekend. Much appreciated.
>
> Secondly, I'm stuck with the following:
>
> 1) Tab-delimited file consisting of 4 data columns (code, pic,

productname,

> price) with variable record size. File size ranges from 2KB to about 9KB.
>
> 2) Using ADO/ASP need to extract the data from this tab-delim file and
> insert it into an Access table, which consists of 6 data columns (autoid,
> code, pic, productname, price, category), which will also contain data

from

> previous imports.
>
> For your ref, I've already put in place a query to delete all records

where

> category = xx, so that the insert basically re-inserts them all again.

This

> delete all and insert all method is OK.
>
> 3) When inserting this tab-delim data also want to add an integer value to
> the 5th column (category) of this Access table, as this is data is part of
> the import system not the tab-delim file.
>
> Any ideas??
>
> Many thanks.
>
> Rgds
>
> Laphan
>
>