Copying from Access to Excel problem

  • Thread starter Thread starter andrefrancis
  • Start date Start date
A

andrefrancis

I have a large Access database (20000 records of 30 fields each) whic
has been imported from Paradox.

Periodically I need to export this to Excel and have long ago given u
on the 2 standard exporting techniques supplied: 1. File: Export and 2
Tools:OfficeLinks:AnalyzeItWithExcel since both generate errors after
long time thinking about it! If anyone has any comments on this, pleas
feel free to say!

Incidentally, I have a 2.6GHz P4 with 1Gb RAM.

I now manually transfer the data 6 cols at a time by 'copying' an
'pasting'. It is slightly tedious but it does the job in about
minutes. (Previously I could wait 15 mins or longer before it reporte
failure).

Finally to my problem. The copied version keeps formats (which i
excellent) but unfortunately also has each cell outlined in black. Whe
I try to get rid of this via Format:Cells:Borders:Remove, Excel doe
not leave the normal light grey edge to the cells. They are no
effectively not bounded as if the gridlines had been switched off
which is quite 'spooky'. How do I get rid of the black outlines t
leave the normal light-grey border
 
Hi
maybe try this the other way round. In Excel goto 'data -
Import External Data - Import Data' and choose your data
source
 
The cell probably have a white fill, instead of No Fill.
Select the cells, and on the Formatting toolbar, click the arrow at the
right side of the Fill Colour button.
Choose No Fill, and the gridlines should reappear.
 
With the access table open, click the box at the top of the rows and th
left of the columns that highlights the entire database.

right click, copy,

got to the excel spreadsheet, click paste special, CSV
 
rbanks said:
*With the access table open, click the box at the top of the rows an
the left of the columns that highlights the entire database.

right click, copy,

got to the excel spreadsheet, click paste special, CSV. *
Click to expand...

This works great ... in about 5 secs ... wow!

Thank you. :) :) :) :) :
 
Back
Top