By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,519 Members | 2,258 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,519 IT Pros & Developers. It's quick & easy.

Trailing Spaces - importing to access or excel

P: n/a
I am doing some genealogy research and I have discovered that there is
a lot of data available on the web in text format. The problem is
that the columns in the files are lined up by spaces. I'd like to be
able to import these files into Access or Excel so that they can be
sorted.

What I plan on doing is adding in commas at the end of each field to
create a csv file. What I need to know is how can I easily remove the
spaces between the comma and the first letter of the next field?

My thought is that I could add commas in front of the field (instead
of at the end) and then have either Access or Excel drop the trailing
spaces. Is there a way to get either Access of Excel to do this? Can
it be done for either leading or trailing spaces?

Any suggestions would be very greatly appreciated.

Thanks,
Tammy

(not looking forward to the editing process....)
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Look up Trim(), RTrim() and LTrim() in Access Help.

Are these text fields fixed width? I'd really try to get
them into Access then manipulate the contents with queries
and/or code.

Good luck.
--
Nick Coe (UK)
AccHelp v1.01 Application Help File Builder
http://www.alphacos.co.uk/
Download Free Demo Copy
----
"Tammy" <ta*****@yahoo.com> wrote in message
news:f7**************************@posting.google.c om...
I am doing some genealogy research and I have discovered
that there is
a lot of data available on the web in text format. The
problem is
that the columns in the files are lined up by spaces. I'd
like to be
able to import these files into Access or Excel so that
they can be
sorted.

What I plan on doing is adding in commas at the end of
each field to
create a csv file. What I need to know is how can I
easily remove the
spaces between the comma and the first letter of the next
field?

My thought is that I could add commas in front of the
field (instead
of at the end) and then have either Access or Excel drop
the trailing
spaces. Is there a way to get either Access of Excel to
do this? Can
it be done for either leading or trailing spaces?

Any suggestions would be very greatly appreciated.

Thanks,
Tammy

(not looking forward to the editing process....)

Nov 13 '05 #2

P: n/a
Folks,

got your details from the newsgroup. Wondered if you could advise.

I'm creating a database and have to import a five field table of text data
from a PDF file.

Obviously I can cut and paste it into excel and then import but I loose the
formatting as it all pastes into one field of excel.

How can I preserve the table formatting and import it into Access
ultimately?

Otherwise I have a truck load of cutting and pasteing ahead.

Any advice greatfully recieved.

Si





"Tammy" <ta*****@yahoo.com> wrote in message
news:f7**************************@posting.google.c om...
I am doing some genealogy research and I have discovered that there is
a lot of data available on the web in text format. The problem is
that the columns in the files are lined up by spaces. I'd like to be
able to import these files into Access or Excel so that they can be
sorted.

What I plan on doing is adding in commas at the end of each field to
create a csv file. What I need to know is how can I easily remove the
spaces between the comma and the first letter of the next field?

My thought is that I could add commas in front of the field (instead
of at the end) and then have either Access or Excel drop the trailing
spaces. Is there a way to get either Access of Excel to do this? Can
it be done for either leading or trailing spaces?

Any suggestions would be very greatly appreciated.

Thanks,
Tammy

(not looking forward to the editing process....)

Nov 13 '05 #3

P: n/a
Folks,

got your details from the newsgroup. Wondered if you could advise.

I'm creating a database and have to import a five field table of text data
from a PDF file.

Obviously I can cut and paste it into excel and then import but I loose the formatting as it all pastes into one field of excel.

How can I preserve the table formatting and import it into Access
ultimately?

Otherwise I have a truck load of cutting and pasteing ahead.

Any advice greatfully recieved.

Si





"Tammy" <ta*****@yahoo.com> wrote in message
news:f7**************************@posting.google.c om...
I am doing some genealogy research and I have discovered that there is
a lot of data available on the web in text format. The problem is
that the columns in the files are lined up by spaces. I'd like to be
able to import these files into Access or Excel so that they can be
sorted.

What I plan on doing is adding in commas at the end of each field to
create a csv file. What I need to know is how can I easily remove the
spaces between the comma and the first letter of the next field?

My thought is that I could add commas in front of the field (instead
of at the end) and then have either Access or Excel drop the trailing
spaces. Is there a way to get either Access of Excel to do this? Can
it be done for either leading or trailing spaces?

Any suggestions would be very greatly appreciated.

Thanks,
Tammy

(not looking forward to the editing process....)


Nov 13 '05 #4

P: n/a
Folks,

got your details from the newsgroup. Wondered if you could advise.

I'm creating a database and have to import a five field table of text data
from a PDF file.

Obviously I can cut and paste it into excel and then import but I loose the
formatting as it all pastes into one field of excel.

How can I preserve the table formatting and import it into Access
ultimately?

Otherwise I have a truck load of cutting and pasteing ahead.

Any advice greatfully recieved.

Si





"Tammy" <ta*****@yahoo.com> wrote in message
news:f7**************************@posting.google.c om...
I am doing some genealogy research and I have discovered that there is
a lot of data available on the web in text format. The problem is
that the columns in the files are lined up by spaces. I'd like to be
able to import these files into Access or Excel so that they can be
sorted.

What I plan on doing is adding in commas at the end of each field to
create a csv file. What I need to know is how can I easily remove the
spaces between the comma and the first letter of the next field?

My thought is that I could add commas in front of the field (instead
of at the end) and then have either Access or Excel drop the trailing
spaces. Is there a way to get either Access of Excel to do this? Can
it be done for either leading or trailing spaces?

Any suggestions would be very greatly appreciated.

Thanks,
Tammy

(not looking forward to the editing process....)

Nov 13 '05 #5

P: n/a
Folks,

got your details from the newsgroup. Wondered if you could advise.

I'm creating a database and have to import a five field table of text data
from a PDF file.

Obviously I can cut and paste it into excel and then import but I loose the formatting as it all pastes into one field of excel.

How can I preserve the table formatting and import it into Access
ultimately?

Otherwise I have a truck load of cutting and pasteing ahead.

Any advice greatfully recieved.

Si





"Tammy" <ta*****@yahoo.com> wrote in message
news:f7**************************@posting.google.c om...
I am doing some genealogy research and I have discovered that there is
a lot of data available on the web in text format. The problem is
that the columns in the files are lined up by spaces. I'd like to be
able to import these files into Access or Excel so that they can be
sorted.

What I plan on doing is adding in commas at the end of each field to
create a csv file. What I need to know is how can I easily remove the
spaces between the comma and the first letter of the next field?

My thought is that I could add commas in front of the field (instead
of at the end) and then have either Access or Excel drop the trailing
spaces. Is there a way to get either Access of Excel to do this? Can
it be done for either leading or trailing spaces?

Any suggestions would be very greatly appreciated.

Thanks,
Tammy

(not looking forward to the editing process....)


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.