Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Exporting Table data help.


Nootch

Recommended Posts

I need a bit of help. I would like to export data from the table in a text file so it can be read in be another program, but I need some help. The structure of how Id like it exported can be found in the file here:

www.happyterminals.com/file.xls

 

Heres the code I made that displays the bame and address info correctly, but I cant figure out how to get the orders to match, or a text file to export.

 

SELECT `orders_id`, `customers_company`, `customers_name`, `customers_street_address`, `customers_city`, `customers_state`, `customers_postcode`, `customers_country`, `delivery_street_address`, `delivery_city`, `delivery_state`, `delivery_postcode`, `delivery_country`
FROM `orders`
ORDER BY `orders`.`orders_id` ASC 
LIMIT 0 , 30

 

Can anyone help?

Link to comment
Share on other sites

Aren't they all?

 

Using phpMyAdmin do the following:

 

1) Backup database

 

2) Open database

 

3) Click on Export tab

 

4) Select table(s) that you want to export

 

5) Check CSV for Ms Excel data or CSV (Ilike just CSV because you have the option to "Put fields names at first row")

 

6) CHECK "SAVE AS" and CHECK "ZIP"

 

7) Click "GO"

 

8) Enter location to save .zip file to (ex: db90741913[1].csv)

 

9) Unzip file and open in MSExcel. You can manipulate to your hearts contents. and save in any format you please.

 

Depending on the version of MSExcel you use, you may have to open MSExcel first and then import the file as a CSV file.

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...