import excel spreadsheet convert to text then trim

  • Thread starter Suttd via AccessMonster.com
  • Start date
S

Suttd via AccessMonster.com

Hi,

I am not very experienced with these things and am not even sure if its
possible, but as the title says I have two spreadsheets that are saved to the
same location same field headings etc they i need to import them "Trim" them
as there are some random spaces and possible convert them to text format so i
can then do a comparrison between the two tables.

If someone could help it would be much appreciated

Thanks

Dave
 
P

pietlinden

Hi,

I am not very experienced with these things and am not even sure if its
possible, but as the title says I have two spreadsheets that are saved to the
same location same field headings etc they i need to import them "Trim" them
as there are some random spaces and possible convert them to text format so i
can then do a comparrison between the two tables.

If someone could help it would be much appreciated

Thanks

Dave
Click to expand...

you can link to them temporarily and write queries against them as if
they were normal Access tables (and do the trimming there). Then you
could turn that select query into an append or make table query.
(might be better if you built the table from scratch so you get the
right field types, though).
 
S

Suttd via AccessMonster.com

Hi,
Click to expand...
[quoted text clipped - 12 lines]
you can link to them temporarily and write queries against them as if
they were normal Access tables (and do the trimming there). Then you
could turn that select query into an append or make table query.
(might be better if you built the table from scratch so you get the
right field types, though).
Click to expand...


Hi,

Thanks for your reply, I just tried to link the excel spreadsheets in but the
one i wanted to trim has spaces in front of the column headings so i think
that is why it comes up with "Name AutoCorrect Save Failures" "Could not save
the table"

Sorry probably something simple .....

Cheers

Dave
 
Top