Skip to main content
Solved

Export customer address data to Excel - SQL

  • November 21, 2022
  • 2 replies
  • 361 views

  • Do Gooder (Customer)

Hi, 

I am trying to export at list of customers to Excel. However, I can see that I am limited to these columns fro the customer table:

Is i possible, using an advanced SQL query, to include the address columns of Address Identity ‘10’ in the export? 
 


Br,
Nielf

Best answer by Link

Hi @Nielf 

of course you can export it from the database.

Use the view customer_info_address

 

2 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • Answer
  • November 21, 2022

Hi @Nielf 

of course you can export it from the database.

Use the view customer_info_address

 


  • 55 replies
  • November 21, 2022

Dear

I did a quick report for this. This you can Export direct to Excel.

Best Regards,
André