Hi all,
i have a system that relies upon data from another database.
When the data is extracted from the database, to be updated into my system, it undergoes a series of action queries, most of which are wrapped in a transaction.
The only step that are not, are the transfertext steps.
Here is a sample of an append query executed against a spreadsheet (.xls)
INSERT INTO test ( FirstName, Surname, PreferredName )
SELECT [Sheet1$].firstname, [Sheet1$].surname, [Sheet1$].prefname
FROM [Sheet1$] IN 'D:\New Folder\test.xls '[Excel 8.0;];
My question is, can I do a similar thing against a '.csv' file?
If not, is there a way I can get the transfertext steps into the transaction?
These are the only steps preventing me from safely getting the data into my system without the chance of the job half completed due to error.
Thanks
i have a system that relies upon data from another database.
When the data is extracted from the database, to be updated into my system, it undergoes a series of action queries, most of which are wrapped in a transaction.
The only step that are not, are the transfertext steps.
Here is a sample of an append query executed against a spreadsheet (.xls)
INSERT INTO test ( FirstName, Surname, PreferredName )
SELECT [Sheet1$].firstname, [Sheet1$].surname, [Sheet1$].prefname
FROM [Sheet1$] IN 'D:\New Folder\test.xls '[Excel 8.0;];
My question is, can I do a similar thing against a '.csv' file?
If not, is there a way I can get the transfertext steps into the transaction?
These are the only steps preventing me from safely getting the data into my system without the chance of the job half completed due to error.
Thanks
