HI..I am a MCSD,
I am trying to generate a flat file using VB6.. In fact, I already did it, but I can not keep the same output format that i have in SQL SErver.. In Visual Basic I did it using the method Save of the object Recordset, but this is not efficent because i need to update the file any time i run the application.. and I need to do this as a batch processing.. Using this method i can just create the file but it does not update date in the flat file.. I tried with the statement Print but I doesn t work.. because when I create the cursor it doesn't print the rows into the file..
I am working in a data migration from one system to another, and I need to load the information from SQL Server to Oracle Finantial database ,however, i need to have a specific format introducing data,i mean, specific spaces between columns and commas..
I tried to do it with SQL Server, it generate the information but it leave some spaces between commas and colummns..
The questions are.. How can I generate this file with Visual Basic 6.0 using SQL Server 6.5 keeping the output format that I specify in SQl Server?
and How can I work batch files with VB6?
