hello,

I have a few questions, please help if you can...

#1. Is there a way to create, edit and delete the system dns's through vb code?

#2. I am using a DAO database to connect to an Excel file then import it into an ms access database. It works fine, but when there is a space in front of the column name in the excel file, it crashes. Is there a way to edit the field names of a recordset that is connected to an excel file through DAO or ADO?

I have tried:
Code:
For I = 0 To rs.Fields.Count -1
  rs.Fields(I).Name = Trim(rs.Field(I).Name)
next
I tried that, but I get an error.

Thanks,
Thai