How to run this code?

[jgelpi16]

I apologize, that was my fault. Copy/Paste error. What you can do is open up the excel spreadsheet you are referring to in your code. With it open step through your code (F8). You'll notice your rows change names to what you are told the code to change them to. All you are currently doing is setting up what will be your field names for the table in Access. Once you have ran through the code import the Excel Spreadsheet and make sure you tell Access to use the first row as headers. This will be your temporary table that you will import to each time.

[compooper]

Oh wow. Thats really impressive. Thanks a lot.

Just a few questions:
-This code changes the headings of my data permanently, which I don't want. Is there a way to just extract the columns into a table in my database?
- Also, is there a way to recognize entire columns starting from row 2?