LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Need help converting MS Access to Excel

Hi,
I'm using MS Access 97, I'm pretty sure (am not in front of that
computer) and Excel of the same vintage.

I would like to convert my MS Access DB to an Excel spreadsheet, but
didn't see any obvious way to do it (didn't see anything likely in the
Export command), and when I tried just copying from Access (not sure
which view I was in, but looking at a grid full of data) and pasting
into Excel, the formatting was messed up (that is, what was in one
field in Access didn't end up in one field in Excel; IIRC, it took
everything from the Access DB and put it into one Excel field).

If anyone has ideas, please let me know. If all else fails, I will
type the whole thing into Excel, but would like to avoid that. :-)

Thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a Access routine into an Excel macro? turtle[_2_] Excel Discussion (Misc queries) 2 February 21st 07 06:38 PM
Converting Excel spreadsheet with formulae to Access database AndyL82 Excel Discussion (Misc queries) 1 February 3rd 07 06:53 PM
export access to excel. change access & update excel at same time fastcar Excel Discussion (Misc queries) 0 June 24th 05 09:27 PM
Converting Forms to Data Access Pages Jason New Users to Excel 0 January 24th 05 03:29 PM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM


All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"