Group Data Export/New Table

  • Thread starter Thread starter Phil Jones
  • Start date Start date
P

Phil Jones

Hi Guys,

I have a table that has a number of duplicate entries and want to export the
grouped data to a CSV or save as a new table.

any ideas?

Thanks
 
Create a query that groups the data as you require.

Use TransferText to export the query to a CSV.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Export Pivot table 1
Difficult Select Query 4
SQL to export query into table 1
Show First and Last Record from Ascended List 3
Query works-Export fails "...you and another user are attempting to change the same data..." 5
Access Sorting and grouping using multiple tables 0
exporting table 2

Back
Top