RE: [MS_AccessPros] Removing junk from Excel files for import

 

Sam-

Define a named range in the spreadsheet that ignores the extraneous info and
then import the range.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
<http://www.viescas.com/> http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of sarmbraugh
Sent: Monday, July 02, 2012 10:38 PM
To: MS_Access_Professionals@yahoogroups.com
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

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 5
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___