VBA code, Import data from Access

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

Thanks for your time and any hel
Jason Frazer
 
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 said:
I have and Access database [Survey info] with table [TbSurveyInfo]. I
Click to expand...
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
Click to expand...
comma delimited in the first column in Excel. Example. In cell one would be
something like this "Site, Project, Date, PLat, ......"
 
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
 
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 said:
They will be used in an existing survey program. It basically is a
Click to expand...
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.
 
Back
Top