Import Data From Access

  • Thread starter Thread starter Todd Quigley
  • Start date Start date
T

Todd Quigley

When doing a query from Access 2000 to Excel 2000, the
table names appear but not the column names. Nor does
the data. It does this for any Access 2000 Databases.
 
Todd

I do this fairly regularly and I've never had any problems.
Sometimes I save the query and then right-click on it and Export it to Excel
format, and sometimes I just select all of the cells in the query, while
it's open, and copy and paste them into Excel. Both ways bring in all of the
information and the column names.

Andy.
 
Thanks Andy, this is what I am doing now, but I used to
have this automated to pull data from Access 95, but for
some reason, it won't work in Access 2000. Copying and
pasting is a bit slow for the spreadsheet we are using.
 
"When doing a query from Access 2000 to Excel 2000"

Could you clarify? Are you doing the query from within Excel with
Access as the target??

If found that if you use Excel to query into either Access or another
Excel file, that if there is no data in the first 25 rows of the table
you are querying, Excel assumes the entire column is blank and records
neither the column header nor the data. All you get is a blank column,
which sounds like what you are getting.

This may only apply to numeric, including date, columns as these are
the only ones I was having sparseness issues with. The only solution
I've been able to find was to reorder my data table so that the
less-sparse rows of data were near the top, ensuring that every column
had at least one row with data in the first 25 rows. Crude, I know, but
it works flawlessly now.
 
Back
Top