Reply to thread

Message: [QUOTE="Bullschmidt, post: 4345534"] You can connect to a csv file (which can be opened in Excel and which an Excel file can be converted into) in good form just as you can to a regular database. And you can have two recordsets open at the same time. So I'd suggest going through this recordset one row at a time and within this loop add a new record to the "real" database's recordset. And for help connecting to a text file using the Jet OLE DB provider: [URL]http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#O[/URL] LEDBProviderForMicrosoftJetText And based on the above link realize that the actual filename does NOT go in the connection string - rather it goes in the SQL statement (definitely a little tricky). Best regards, J. Paul Schmidt, Freelance ASP Web Developer [URL]http://www.Bullschmidt.com[/URL] ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool... [/QUOTE]