OutputTo Command

[Jason Frazer]

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

 

[Dirk Goldgar]

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

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