ETL and Data Integration tools - Modern ETL software for everyone

Could you please let me know why you have to use ODBC for Add new records and Update old records? why you can't use the same connection?

Can you select to skip ROWS from Execel before importing?

Could you please let me know if I can change this 0-42563-06804-2 into 042563068042 before importing?

Whould you say that your Visual Importer is my best bet to import update del
records in MSSQL from Excell
Thank you
John

Could you please let me know why you have to use ODBC for Add new records and Update old records? why you can't use the same connection?

MS Sql connection uses bcp interface to load data into the database.
This interface was designed by Microsoft especially for fast data load.
Unfotuntately it is not posssible to use it to perform updates, therefore you have to use Odbc connection instead.

Can you select to skip ROWS from Execel before importing?
you can use filter for that

GetSystemVariable('RECORDNUMBER')>10

Could you please let me know if I can change this 0-42563-06804-2 into 042563068042 before importing

You can use calculated fields for that

Replace(String,OldPattern,NewPattern):String

Mike

Correction to previous message

This will filter first 10 records

StringToInteger(GetSystemVariable('RECORDNUMBER'))>10

Sience I am new to all this could you please advise me how to transalate
this Replace(String,OldPattern,NewPattern):String into my real example
change this 0-42563-06804-2 into 042563068042 before importing?
Thank you
John

Hi

For the field you want to load into
set mapping type to calcuated
type in calculation box
Replace("[F1]","-","")
where [F1] is your source field

There is an example in documentaion "How to perform calculations"

Mike