Adding records to an SQL table

I trying to add records from a table in DBF format (created with Visual FoxPro) into an SQL table created with SQL Server 2005.

I first converted the dbf file into an ascii file and then in the Query Editor in the SQL Server I typed:

use [c:\develope\sql\sqldata\psw.listener]

append from 'c:\develope\sql\data\listener.txt' type sdf

go

and then I pressed F5. I get an error that says:

Msg 911, Level 16, State 1, Line 1

Could not locate entry in sysdatabases for database 'c:\develope\sql\sqldata\psw.listener'. No entry found with that name. Make sure that the name is entered correctly.

I checked in the directory c:\develope\sql\sqldata\ and the file psw.mdf is there and when I look in the psw database, the table listener is also there.

Could someone tell me what is going wrong? Also, how do I append the whole dbf table onto an SQL table. there's about 6000 records.

Thanks.

Hi Bob,

the question as asked does not seem to be for the Integration Services forum.

You should be able to do this using SSIS though by using a data flow with a source to read rows from DBF and a destination component to load those rows into your SQL Server table.

HTH.