not sure.. when i export as "csv for excel", i have to go through the text-to-columns steps you referenced. however, when i export as plain old csv, it opens up fine in excel, already split into columns correctly, and the total/sum works fine on the order totals. not sure what to tell ya.
Results 1 to 10 of 13
Threaded View
-
23 May 2013, 07:34 PM #10
Zen Follower
- Join Date
- Oct 2007
- Posts
- 143
- Plugin Contributions
- 0
Re: Need to get all orders in a date range by sql
Reply With QuoteSimilar Threads
-
v151 Need an SQL query to select a range of products and update the product status to 0
By oztraveller06 in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 8 Mar 2014, 07:33 AM -
v150 Remove ALL customers and ALL orders before a certain date and reset counter history.
By hawkwynd in forum Managing Customers and OrdersReplies: 4Last Post: 10 Dec 2013, 03:22 AM -
Need help to SQL change the Product Add Date
By explorer1979 in forum General QuestionsReplies: 2Last Post: 1 Sep 2012, 03:22 PM -
HELP! All Orders Get Stuck
By Pammydee in forum Managing Customers and OrdersReplies: 17Last Post: 25 Jun 2006, 04:30 AM -
SQL Error 1264 Out of range value adjusted
By NACServices in forum Setting Up Categories, Products, AttributesReplies: 7Last Post: 25 May 2006, 01:53 PM
Bookmarks