Search results for query: *

[shocked]and to be clear, my table IS called tblSN137 and my tDoCmd.TransferText acImportFixed does reflect the correct names of tables/import specifications.I was just going to post general code and neglected to change those "tblSN137"s [sadeyes]

I am beyond confused. When I do a manual import of this data into a new table I have no serious issues. Only when I use transfer text I get numerous erros and a mostly blank table. I am using the saved import specification of the manual import. Also, I am clearing out the table with VBA to do a...

No it is spaced.

This is all around handy. I could use this often in the future. I'm still new to SQL so this really helps. Thank you Golom!

I feel that the best way to explain this is with a little background. I was tasked with importing some .txt files into an Access database. The method I chose was to import the stripped data into a new .txt file and then into the database via DoCmd.transfer. This works great and I have no issues...

Ah, yes. That is exactly what is happeneing. Best solution, new import specification?

after some consideration I have one issue and am not sure what's causing it. with: UPDATE tblSnapshotMASTER SET ITEM_NUMBER = Mid(ITEM_NUMBER,7,3) & "-" & Left(ITEM_NUMBER,6) WHERE Len(ITEM_NUMBER) = 12; where my output: R51-[highlight #FCE94F][/highlight] T5820 why is the space there I...

Great eyes, Golom. Thank you PHV! You guys are awesome. Everything is running great! Going to do some data validation just to be safe but it looks awesome!

No worries, I started using copies.

The result is the table view of MyTable with a field Expr1000 where cell A1 has a 0. My process is to create a new Query, go to SQL design, enter statement, then run.

Not sure why but it says it's updating 0 rows...

So it would be like this? UPDATE MyTable SET ITEM_NUMBER = Format(Mid(ITEM_NUMBER,6,3) & "-" & Left(ITEM_NUMBER,5) WHERE Len(ITEM_NUMBER) = 11 Implementation should just be ? 1. New query 2. Design view 3. input statement Would you advise trying it on a copy tbl?

Amazing! Thank you!

That syntax was corret, however I was wrong about functionality. What I am actually looking for is a SQL query statement that will Before CS220061000 T5325204000 14W47163000 TBR20131000 05226R52000 After: 061-CS220 204-T5325 163-14W47 131-TBR20 R52-05226 After a search I'm not seeing...

Hello, I'm pretty new to Access and am trying out some new things. I want to add a dash to a table field data like : Before: CS220061000 T5325204000 14W47163000 TBR20131000 After: CS2-20061000 T53-25204000 14W-47163000 TBR-20131000 the field name is ITEM_NUMBER I'm thinking about a Query...

So this thread has proven to be more than helpful. You guys are great! I don't in any way need this for functionality but I'm just currious, what would be a good way to eliminate in line strings? Like, the "L" that repeats throught the record. Also, Golom that's an awesome answer to the date...

Wait, it's all a file format issue! You were right on about the RTF issue! Thank you so much!

I think my constraints are in the wrong place? I have them in General. Sorry I'm new to VBA feel like I'm missing something obvious.

I'm not sure why but now I'm just getting the unfiltered data...

Of course: INPUT DATA QUERY NAME . . . . . DC31INV LIBRARY NAME . . . . QGPL FILE LIBRARY MEMBER FORMAT...