Recent content by Zach Lau

Thank you so much. I can do this.

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

So I work for a company that does data management for public school testing for most of the state of Indiana. The files are downloaded from a company called Acuity. They contain student information and scores. The columns might be different depending on the type of test and other factors...

I am in access vba. I have a batch of csv files which come in many formats. Currently I have a code that imports the csv files into a temptable, appends to a temporary running table, renames the imported csv file and eventually the running table and exports to several csv files. The code...

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

Ok, I figured that part out. I was calling an empty table earlier in the code. My apologies. I've been looking at this all day and it was running:) May I ask one more question? Is this the correct statement that I am looking for? SQLlowgrade = "SELECT TOP 1 [" & tableexportname & "].* INTO...

This is for a file naming convention.

1. Well, I'm attempting to break down a larger issue. The code will eventually sort the records then select the Top 1 into lowgrade. Then it will sort desc and select the top record into high grade. I'm then doing a DLookup to get the highest and lowest grade level in a table of student state...

Ok, so I tried that. I'm still getting the same thing and I did delete the temp tables before executing the code. Any other idea? I cannot for the life of me figure out why the query executes in the wizard, but not here. Thanks.

I actually did that. No errors and 0 records are being transferred. I'm at my whits end. With CurrentDb .Execute SQLlowgrade, dbFailOnError MsgBox "Low records inserted: " & .RecordsAffected .Execute SQLhighgrade, dbFailOnError MsgBox "High records inserted: " &...

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