Search results

I have been looking over and over this issue multiple times and can't seem to get my head around it. I have a VB6 application with connection to an Access (2000/2003) database that does all SORTS of fun data manipulation. In fact, all of the same VB6 functions and subs are replicated to a...

@Dylan - Okay, my post may have been a bit misleading. I'm actually doing the import through a Visual Basic 6 project, not working through Access or Excel VBA. However, I've actually gotten this problem figured out. It's requiring the type of data manipulation I identified in my last post...

A new thought was posed to me by a co-worker: What if we put the apostrophe character to ALL of the fields in the column of Excel data in question? This won't affect the data in the fields already setup as text, but for the records with "numeric" data, it will force it to a text string. I...

@Dylan - Well, the problem occurs in multiple records, so that's that then. :( @gemma - Thanks for the insight. I may have to do that at some point. ;) The thing is, though, that the column is already being treated as text. In fact, my VB code specifically identifies the field in Excel as...

Well, I'm glad I came across this forum/thread. I'm currently in the process of developing a VB application that imports data from an Excel spreadsheet to an Access database table. The only problem I have is that, like the OP, I'm having issues where some of the data is getting ignored during...