Search results for query: *

I currently have an Access table with a few demographic fields and 36 "Item" fields, named "ITEM1", ITEM2", ITEM3" etc., with numerical data in each field. There are thousands of records within this table. I need to switch the current horizontal orientation of this table to a vertical layout...

To answer Skip's question...no, in this particular case, missing data doesn't concern me. I tried your code, MaZeWorX...it worked beautifully!!! I can't thank you enough! Susan :-)

My code imports an Excel file when the user clicks on an "Import" button. This works great, except that a "import errors" table is automatically created by Access during the process. Does anyone know what code I can use to delete the table that is created? I have used the DeleteObject method...

What I am trying to do is export data from my Access database to an Excel spreadsheet which updates charts on the Charts worksheet, and then open an Access report with the Charts worksheet embedded. So my question is: Is there a way to embed part of an Excel worksheet into an Access Report? I...

Is there a way to embed an Excel worksheet in an Access Report? If so, can anyone give me some code which will do that? I am a beginner at using Visual Basic. Thanks.