Re: import excel spreadsheet convert to text then trim

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Jul 23, 3:29 am, "Suttd via AccessMonster.com" <u25367@uwe> wrote:
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

--
Message posted viahttp://www.accessmonster.com

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).
.

Quantcast