I'm trying to import data from an Excel 2000 spreadsheet. Everything works great except it's including the first row as column names. In the help file it says in the 'connection properties' dialog box to use the 'file format' button to launch the file format wizard where you can change the settings. Unfortunately, I don't have a 'file format' button in my 'connection properties' dialog box. Is there some other way to change these settings? Thanks for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS import from Excel 2000
- Thread starter geissler
- Start date
Similar threads
- Locked
- Question
- Locked
- Question