G
Guest
I'm importing a text file into my access db however the text file has the
following rows that I do not want imported
The First 4 rows
Source File Name : CDW - Facility
File Create Date : 20060209
Time Period : 200512
SRC_SYS_ID|CORP_NBR|IP_ID|OBLIGOR_NUM|
And the last 3 rows
Total Number of records - 50516
Total Facility Limit - 82529811024.27
Total Charge Off - 638805636.63
This is the SQL command I am useing to import the data
DoCmd.TransferText , "EC_Facility_Specification v4 (type)", "(1) ec_facility
- New", varFilename, True
DoCmd.RunSQL "SELECT [obligor_num] & ['_'] & [obligation_num] AS
[obligor & obligation], [(1) ec_facility - new].* INTO Current_Month_Data
FROM [(1) ec_facility - new]"
Can some one help so when I import the text file those rows will be deleted
Thanks
Chris
following rows that I do not want imported
The First 4 rows
Source File Name : CDW - Facility
File Create Date : 20060209
Time Period : 200512
SRC_SYS_ID|CORP_NBR|IP_ID|OBLIGOR_NUM|
And the last 3 rows
Total Number of records - 50516
Total Facility Limit - 82529811024.27
Total Charge Off - 638805636.63
This is the SQL command I am useing to import the data
DoCmd.TransferText , "EC_Facility_Specification v4 (type)", "(1) ec_facility
- New", varFilename, True
DoCmd.RunSQL "SELECT [obligor_num] & ['_'] & [obligation_num] AS
[obligor & obligation], [(1) ec_facility - new].* INTO Current_Month_Data
FROM [(1) ec_facility - new]"
Can some one help so when I import the text file those rows will be deleted
Thanks
Chris