View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Wiggins[_3_] Andy Wiggins[_3_] is offline
external usenet poster
 
Posts: 35
Default 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