Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data from Access | Excel Discussion (Misc queries) | |||
Import data from Access 2007 | Excel Discussion (Misc queries) | |||
Can't import data to access | Excel Discussion (Misc queries) | |||
Import Charts and data to Access | Charts and Charting in Excel | |||
data import and export in to access | Excel Discussion (Misc queries) |