Not applicable
2015-01-30
01:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Delete First Record in Data Load
Hello,
I am attempting to load a table, but I need to delete the first record. My header is properly identified, but the first row below it needs to be removed in the data load.
How do I go about doing this?
2,241 Views
1 Solution
Accepted Solutions
maxgro
MVP
2015-01-30
01:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1 Reply
maxgro
MVP
2015-01-30
01:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
load *
from yourtable
where recno() <> 1;