OutputTo Command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have and Access database [Survey info] with table [TbSurveyInfo]. I want to import the table into a new excel table. From a click of a button
The trick is, How can i combine all the fields in each record to become comma delimited in the first column in Excel. Example. In cell one for each record would be something like this "Site, Project, Date, Plat, ......

Thanks for your time and any hel
Jason Fraze
 
Jason Frazer said:
I have and Access database [Survey info] with table [TbSurveyInfo].
I want to import the table into a new excel table. From a click of a
button.
The trick is, How can i combine all the fields in each record to
become comma delimited in the first column in Excel. Example. In
cell one for each record would be something like this "Site, Project,
Date, Plat, ......"

Thanks for your time and any help
Jason Frazer
Click to expand...

You could build a query that creates a calculated field concatenating
all the fields, separated by commas, and export that to your Excel
worksheet.
 
Back
Top