G Guest Mar 23, 2007 #1 Hi, How do I export data from an Access query or table to a csv file? Thanks in advance
M MasterGaurav \(www.edujini-labs.com\) Mar 23, 2007 #2 Hi, How do I export data from an Access query or table to a csv file? Click to expand... I don't think there's a direct mechanism available. You can probably write a simple code for the same... it should be pretty straight forward. -- Happy Hacking, Gaurav Vaish | www.mastergaurav.com www.edujini-labs.com http://eduzine.edujini-labs.com -----------------------------------------
Hi, How do I export data from an Access query or table to a csv file? Click to expand... I don't think there's a direct mechanism available. You can probably write a simple code for the same... it should be pretty straight forward. -- Happy Hacking, Gaurav Vaish | www.mastergaurav.com www.edujini-labs.com http://eduzine.edujini-labs.com -----------------------------------------
R Rad [Visual C# MVP] Mar 25, 2007 #3 Hi, How do I export data from an Access query or table to a csv file? Thanks in advance Click to expand... Take a look at a libary called FileHelpers. Perfect for exactly this sort of thing. Alternatively if you have access to SQL 2000 you can use DTS (SSIS for SQL 2005) to accomplish the same thing.
Hi, How do I export data from an Access query or table to a csv file? Thanks in advance Click to expand... Take a look at a libary called FileHelpers. Perfect for exactly this sort of thing. Alternatively if you have access to SQL 2000 you can use DTS (SSIS for SQL 2005) to accomplish the same thing.