Extracting Info from Excel

[mays0515]

Hi All,

I have a bunch of excel workbooks where the info repeats itself. I am trying to move all the info to Access. How do I extract the info from an excel spreadsheet and have a table created from that info? (for example: The columns on one of the spreadsheets are ProductName, Sales and Percent Increase)---how can I extract this info into an Access table?

Thanks!
Mays

 

[ghudson]

You have to import the data from Excel and into Access. But first you must ensure that your data in Excel is properly formatted. Each column in Excel must be consistent and have the same format for each row within each column or else Access will not import all of your data from Excel.

From the Access menu bar, click...

File / Get External Data / Import

Now find and select your file [you must change the "Files of type" combo box to the "Microsoft Excel" option to 'see' Excel files] and then click the Import button and follow the import wizard's options.

Good luck!