Hi am having a runtime problem with the code you gave me, am getting a error on the WScript , it say object required: WScript  , code 0 .

The URL is static and its a access database that i down load. i will try the code and let you know how i get on, am using SQL 2000,...

ok here you go i've copied the text in the format it is in, just to let you know i have to rename the file from .ttx to txt

Thanks

"REQUEST_ID" "SHIPMENT_ID" "PLACE_ID" "PLACE_ID_SHIP_TO" "PLACE_ID_TO_BILL" "NAME" "CITY" "ZIPPOST" "PHY_SVC_GRP_C" "REQ_CONTR_TYPE" "CONTRACT_ID_NOPRD" "PRODUCT_NAME" "SERIAL_ID" "CONTR_ID_PRODUCT" "PART_LINE_CODE" "PART_ID" "STD COST...

I had it set up the way "Knut's" told me, but my file is causing me problems, so i have to use Text qualifier  as <None> and then set them...

Hi i have the same problem, but am importing a txt file to a access database this is done via a DTS there is no script like replace in access...

Hi guys i have the same problem regarding the text at the start of my file i want to discard it but then i do have my column headers, if...

I've got this far but i still have one issues with it... read on..

I have a query for the cancel field calls.(See below), i've got...

Hi Jeff, am still working on it, i will post a update in the next few days.

Thanks

Francis

Hi Jeff, am back again for your help i've been given new requierement, for this report am workong on and i've now a better understanding of what i need, regards...

Hi Jeff your knowledge is priceless thanks, i will go through the code to understand it in detail now.

Hi Jeff, thanks for the very clear example.

I've just one more question,

I've added 3 more rows of data at the end of the insert step, these are valid calls that do not...

The system create a new case id for ever call so i cannot relate the calls by case id, the only wat i can relate the calls is by the...

I want to set a void column to 1 or 0

What i have is a table that shows Cancelled = F and ServiceEvent = T i have initally set the...

I was thinking, that seeing as all the data is in one table that if i create a view that holds all the data that either holds all the

The DTS get's data from a source table for the last 8 days, each step in the DTS updates this table, but them updates are using sub views to compare...