Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sherrys
Starting Member
37 Posts |
 Posted - 2005-09-01 : 10:29:47
|
| I am trying to import a dbase 5 file. I am getting an error message "Data source for column 1 is not available. Record is deleted". I have opened the file in excel and it shows blank lines in the middle of the spreadsheet. I have opened the file in Access and it shows the records as #deleted. How can I make the dts import skip these lines? I have tried to use a query for the import where column 1 is not null. It didn't work. It says it can't read column 1 to do the compare. I don't want to have to manually edit the file to make the import work, because I have to import 42 of these files. Please Help. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-01 : 10:59:36
|
| Doesn't answer your question, but in case it helps!:IIRC dBase used to put some special character in the first character of a record to mark it as deleted.Sounds like whatever is trying to import the dBase file doesn't know about that - is there a newer/different driver [ODBC or whatever] you could try?Kristen |
 |
|
|
|
|
|
Deleted rows in a DBase Import