I have a csv file, one field is called partnumber though it can contain letters and hyphens. This field when read using a csv.dsn and sent to a text field in Access. The problem is that if the field is all numbers, it works, if it contains letters or a hyphen, I get a blank entry in the field. Any ideas...??<BR><BR>Mickey<BR><BR>smaple code:<BR>&#060;%response.buffer=true%&#062;<BR>&#0 60;!-- #include virtual="common/adovbs.inc" --&#062;<BR>&#060;!--#include file="common.asp"--&#062;<BR><BR>&#060;%<BR><BR><BR>ConnectData<BR><B R>Dim rs<BR>dim query<BR><BR><BR>Set rs=Server.CreateObject("ADODB.RecordSet")<BR>query = "SELECT * FROM products"<BR>rs.Open query, Connect, adOpenDynamic, adLockOptimistic<BR><BR><BR><BR>Dim sDSNFile<BR>sDSNFile = "CSV.dsn"<BR><BR>&#039 Let&#039s now dynamically retrieve the current directory<BR>Dim sScriptDir<BR>sScriptDir = Request.ServerVariables("SCRIPT_NAME")<BR>sScriptD ir = StrReverse(sScriptDir)<BR>sScriptDir = Mid(sScriptDir, InStr(1, sScriptDir, "/"))<BR>sScriptDir = StrReverse(sScriptDir)<BR><BR>&#039 Time to construct our dynamic DSN<BR>Dim sPath, sDSN<BR>sPath = Server.MapPath(sScriptDir) & "\"<BR>sDSN = "FileDSN=" & sPath & sDSNFile & _<BR> ";DefaultDir=" & sPath & _<BR> ";DBQ=" & sPath & ";"<BR><BR>&#039 Building Data Connection<BR>Dim Conn, rsfile<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Op en sDSN<BR><BR>&#039 Get csv info<BR>Dim sql<BR>sql = "SELECT * FROM parts2.txt"<BR><BR>&#039Implicitly create a recordset object with the<BR>&#039results of this query<BR>set rsfile = conn.execute(sql)<BR><BR>Do Until rsfile.EOF<BR><BR>rs.AddNew<BR>rs("category") = rsfile("categ")<BR>rs("partnumber") = rsfile("part number")<BR>rs("description") = rsfile("description")<BR>rs("package") = rsfile("package") &#039line 56<BR>rs("listprice") = rsfile("list price")<BR>rs("unit") = rsfile("unit")<BR>rs("pkgprice") = rsfile("pkg price")<BR>rs("vendornum") = rsfile("vend#")<BR>rs("vendorname") = rsfile("vend-name")<BR>rs.Update<BR><BR>rsfile.MoveNext<BR>Loop <BR><BR><BR><BR>rsfile.movefirst<BR>Do until rsfile.EOF<BR>Response.Write rsfile("part number") & " - " & rsfile("list price") & "<BR>"<BR>rsfile.movenext<BR>loop<BR><BR><BR><BR>r s.Close<BR>Set rs = Nothing<BR>&#039finished adding item to itemlist<BR>%&#062;<BR><BR><BR><BR>