Hi Sam,
without writing code to open it and detect the range, the best thing to do is this:
1. open the Excel Workbook
2. select the sheet with your data
3. click in a data column that has values all the way down
4. press Ctrl-Shirt-* to select the range
if it is not right, then manually select all your data
5. click in the Address Box (where it says B1, C12, whatever is your active cell)
6. create a Range name --: ie: MyImportData --> and press ENTER
on the Formulas ribbon, choose Name Manager to change what a Name refers to.
A Name can refer to a value or range of cells.
In Access, instead of listing Sheets, list Range Names
Warm Regards,
Crystal
Learn Access on YouTube
http://www.YouTube.com/LearnAccessByCrystal
*
(: have an awesome day :)
*
________________________________
From: sarmbraugh <sarmbraugh@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, July 2, 2012 2:38 PM
Subject: [MS_AccessPros] Removing junk from Excel files for import
More questions!
Does anyone have ideas about simple ways to detect and ignore extraneous data in an Excel file that's being imported, like say if there's extra text in the first few rows before the column headings?
Thanks,
Sam
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar