VBA code, Import data from Access

[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 would be something like this "Site, Project, Date, PLat, ......

Thanks for your time and any hel
Jason Frazer

 

[Andy Wiggins]

How do you intend to use them if they are imported as comma delimited?

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

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 would be
something like this "Site, Project, Date, PLat, ......"

 

[Jason Frazer]

They will be used in an existing survey program. It basically is a scheduling-employee management system. This will only take on column for input. Currently someone retypes all the information in the first colum in a tab delimited form

Can you hel

Thank
Jason Frazer

 

[Andy Wiggins]

Maybe I'm missing something, but why not just import the csv file into
separate cells in the first place?
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

They will be used in an existing survey program. It basically is a

scheduling-employee management system. This will only take on column for
input. Currently someone retypes all the information in the first colum in
a tab delimited form.