Importing CSV files into SQL Server actually is pretty easy.  Using Crystal for data from a file instead of a database can be very slow - especially if it's a large dataset.  Crystal has to do ALL of the work to process the data instead of letting the database do it.  I don't think you have the option to write a command against a CSV file like you do when you're connected to the database.

If you have access to SQL Server Management Studio, it has an import function that will allow you to create a new table or append to an existing table.  Right-click on the database you want to import to, select Tasks, and then select Import Data.  Once you've configured this for the first time, you can save it as an SSIS package that can be run automatically as needed.  (NOTE:  I'm using SQL Server 2005 - I'm not sure how this process works for any other version.)

-Dell