Tag Archive : CSV

The Microsoft Jet database engine could not find the object

Posted on June 2, 2009 in: Access, Error Messages|3 Comments

1
Digg me

The Microsoft Jet database engine could not find the object ‘ ‘. Make sure the object exists and that you spell its name and the path name correctly.

Today I got this error when I was trying to import a CSV file into Access database 2003. Even though I was trying to load this from my C: drive I was getting this error.

After couple of tries found that filename “currentproc.20090531.csv” had an extra “.”  and that was the problem.

So renamed the file to 20090531.csv and it worked :)

Happy importing.

How to Save Query results as .CSV or Excel file using SQLServer 2005 Studio

Posted on June 11, 2008 in: Database, SQLServer 2005|1 Comment

0
Digg me

Here is the simple way to save query results as .csv or .xls  file using SqlServer Management Studio.

Execute your query

Example : Select * from AdventureWorks.Person.Address
Right Click on Left top corner

Select “Save Result As” to save as .csv file

OR

Select “Copy” and paste the result in an Excel sheet.