why don't u use the bcp program from SQL Server 6.5 > > >Hi > >I have a formatted text file that I need to import and upload to an >SQL >table on our SQL server. >What would be the best method? Thanks... > >(PS I currently use all views to access the remote data) > >Gary