Search results

  1. Z

    docmd.transfertext opens csv with improper format

    I have a now somewhat large app that depends on this line of code. I am using DoCmd.TransferText to import a csv file into a temp table. The entire program depends on the data being imported from the csv file entirely in text format. About 90% of my csv files do import entirely in text. I...
  2. Z

    Writing to a csv

    Hello. I have an issue that I am trying to sort through. I'm working with several (100's) or different csv files. I came upon a fairly large issue. I have a csv file format with three field names which are the exact same thing. My thought is that I would open the csv file using a DAO...
  3. Z

    SQL in VBA Access 2010

    I've been racking my brains over this for the better part of today. For the live of me I cannot get to the bottom of this. I have a sub called Export. For the file naming, I must pull information from tables. The code below is a small part of the function, but it continues to return a blank...
Back
Top Bottom