I had an application that used Access. I'm migrating it to SQL Server and have run into a bit of a problem.<BR><BR>The user receives Access files from an outside source that need to be imported into the application. I used to use a SQL command:<BR><BR>SELECT tblSurvey.*<BR>INTO tblTempSurvey IN 'C:incoming.mdb'<BR>FROM (tblSurvey)<BR>WHERE FormID IS NOT NULL<BR><BR>How could I accomplish this same task in T-SQL? I tried the above code (because I like pain) and it failed.<BR><BR>So, how might I accomplish this?<BR><BR>Thanks for any help!