I have a project i am trying to do with a template. I have a cad package
that i can generate a bill of materials for and specify a template for. the
template seems to be pretty standard, some of the cells show to be
"column=count" or whatever the field in the cad package is. also some are
"field=xxxx". When i run this report from the cad package all is good.

The problem comes in because we have just switched cad packages. Now all i
can generate out of the cad package are text delimited (csv) files. Is there
a way to import this data into excel?

I would like to be able to specify columns in excel and have them match up
with the csv file. However the data will change from time to time so i dont
know how many rows i will need. the previous cad package/template didnt seem
to specify this. I have tried but i cannot figure out how the previous
package did it unless it was something integrated into the package.

Thanks for any help you can give.

dm.

You could open them in excel (as a new workbook), then move those columns of
data to anywhere you wanted.



Daniel M wrote:

I have a project i am trying to do with a template. I have a cad package
that i can generate a bill of materials for and specify a template for. the
template seems to be pretty standard, some of the cells show to be
"column=count" or whatever the field in the cad package is. also some are
"field=xxxx". When i run this report from the cad package all is good.

The problem comes in because we have just switched cad packages. Now all i
can generate out of the cad package are text delimited (csv) files. Is there
a way to import this data into excel?

I would like to be able to specify columns in excel and have them match up
with the csv file. However the data will change from time to time so i dont
know how many rows i will need. the previous cad package/template didnt seem
to specify this. I have tried but i cannot figure out how the previous
package did it unless it was something integrated into the package.

Thanks for any help you can give.

dm.


--

Dave Peterson

Yes, I know i can bring it into excel and then manipulate it. However what i
would like to do is to have it do it automatically.

The data is something along the lines of...

part,description,count,refdes
a, part a, 1, p1

and so on.


"Dave Peterson" wrote in message
...
You could open them in excel (as a new workbook), then move those columns
of
data to anywhere you wanted.



Daniel M wrote:

I have a project i am trying to do with a template. I have a cad package
that i can generate a bill of materials for and specify a template for.
the
template seems to be pretty standard, some of the cells show to be
"column=count" or whatever the field in the cad package is. also some
are
"field=xxxx". When i run this report from the cad package all is good.

The problem comes in because we have just switched cad packages. Now all
i
can generate out of the cad package are text delimited (csv) files. Is
there
a way to import this data into excel?

I would like to be able to specify columns in excel and have them match
up
with the csv file. However the data will change from time to time so i
dont
know how many rows i will need. the previous cad package/template didnt
seem
to specify this. I have tried but i cannot figure out how the previous
package did it unless it was something integrated into the package.

Thanks for any help you can give.

dm.


--

Dave Peterson

Turn the macro recorder on, step through the process of importing the file
and manipulating the data, and you have your automation.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Daniel M" wrote in message
ink.net...
Yes, I know i can bring it into excel and then manipulate it. However what
i
would like to do is to have it do it automatically.

The data is something along the lines of...

part,description,count,refdes
a, part a, 1, p1

and so on.


"Dave Peterson" wrote in message
...
You could open them in excel (as a new workbook), then move those
columns
of
data to anywhere you wanted.



Daniel M wrote:

I have a project i am trying to do with a template. I have a cad
package
that i can generate a bill of materials for and specify a template
for.
the
template seems to be pretty standard, some of the cells show to be
"column=count" or whatever the field in the cad package is. also some
are
"field=xxxx". When i run this report from the cad package all is good.

The problem comes in because we have just switched cad packages. Now
all
i
can generate out of the cad package are text delimited (csv) files. Is
there
a way to import this data into excel?

I would like to be able to specify columns in excel and have them
match
up
with the csv file. However the data will change from time to time so i
dont
know how many rows i will need. the previous cad package/template
didnt
seem
to specify this. I have tried but i cannot figure out how the previous
package did it unless it was something integrated into the package.

Thanks for any help you can give.

dm.


--

Dave Peterson