Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. HelloWorldGuy

    Text import works manually but not with VBA script

    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...
  2. HelloWorldGuy

    import .txt file parse via new table?

    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...
  3. HelloWorldGuy

    Adding a dash to existing table field?

    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...
  4. HelloWorldGuy

    VBA text manipulation

    I have a question in reference to thread705-1379089 I'm trying to format one of the ideas there to what I need. All I want to do is import the column data from a file once a week. the file has 6 lines of headder that will always be deleted then a repeating three lines that look like: 07/03/12...

Part and Inventory Search

Back
Top