Export to Access, Workbook Treated as a Query Response

  • Thread starter ConfusedNHouston
  • Start date
C

ConfusedNHouston

I ran a query on the mainframe and via ODBC, pulled the results into Excel.
I had a need to add a column of data. I did so and I saved the Excel file.
When I go to Access (after importing the Excel spredsheet as a new Access
table), my change (the additional column) is not there.

I got to poking around and for some reason Access is treating the worksheet
like it's not a worksheet at all, but instead, like it's a query (or a
response to a query). Is there anything I can do in Excel to prevent or
reverse this?

Here's how Access "views" the range - "UKRM!Query_from_AS400
 
F

FSt1

hi
not sure but when you imported the query from AS400, did you rename the
range in excel. the query imported into excel and excel gave it the name
query_from_AS400 and that is the named range that access imported. if you did
not resize the named range (as well as rename) then access did not pull in
any extra columns. it pulled the named range that was imported into excel.

my thoughts(guess)
regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Renaming columns in MS Query 2
Excel Format Question -- CC:SS treated as time HH:mm 2
Excel Query setup 0
Access query not showing as sources for pivot table 2
Import Data from Access 1
Columns formatted As Dates Are Exported as a Number to Text 1
No Results returned from Access query 3

Top