exporting Excel to Access

  • Thread starter Thread starter Kevin Walsh
  • Start date Start date
K

Kevin Walsh

Trying to format an excel table to export to Access. It
is largely a text table. In order for all the text to
appear in the appropriate cell so as to export it all, we
have had to go to each line of text within the cell and
hit Alt-Enter...

Is there a way to do this globally, on a group of cells,
or at least on the entire cell rather than having to go
line to line within the cells? THis was a cure effected
by my former computer assistant, and I just believe there
is a larger scale cure than going to each line of text.
There are apporoximately 7000 cells I would have to do
this to.

Any suggestions?
 
Hi

You could try saving the sheet as 'tab delimited' (.txt) and using File /
Get external data / Import from within Access. This will bring in all of the
data AFAIK
 
Back
Top