VBA code, Import data from Access
 

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

VBA code, Import data from Access
 

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"



"Jason Frazer" wrote in message
...
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 help
Jason Frazer

VBA code, Import data from Access
 

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

VBA code, Import data from Access
 

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"



"Jason Frazer" wrote in message
...
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 help

Thanks
Jason Frazer