Search results

This worked: Sub exportTextNoob() Dim iCntr As Long Dim strFile_Path As String strFile_Path = "C:\myfilepath" Open strFile_Path For Output As #1 For iCntr = 1 To Cells(Rows.Count, "F").End(xlUp).row Print #1, Range("F" & iCntr) Next iCntr Close #1 End Sub

Yes. All I'm trying to do is copy the data in column F to the data.txt file

Good question. Sometimes the cells are blank.

Hi, I have the following sub that exports a column (F) from an Excel file to a text file named data.txt. This has been working, but my data set has grown and for some reason this routine does not copy all of the data from column F, stopping at 43,020 lines. I have about 180k lines that need...

So this was the correct solution. So strange, but writing Create view viewname AS <query> worked. However, when I went to the view design and simply wrote the query text in the query box, it gave me the aforementioned error. Does anyone know why? Anyways, thank you everyone!!!!

I don't think so in this case. The data (sensitive) is being transferred to my server through another intermediary server. I have copies of the tables, not references to the tables on an external server. I created the schema campus because that's how the upstream data people wanted to send it.

Campus is a schema that is coming over from another server, so I'm prefixing the table names with that schema. I just think it's strange this works as a query but not a view.

I understand that it may be necessary to share my underlying table structure - but the fact that it executes as a query leads me to believe it's not a systemic issue in the query, but just that i'm missing some important detail.

Hello all, The following SQL statement works in SQL Server Management Studio as a query on my server: select p.stateID, p.personID, hm.memberID, hm.startDate as householdMemberStartDate, hm.endDate as householdMemberEndDate, hm.secondary as householdMemberSecondary, hl.locationID...

Thanks Sonic. The 'NOT EXISTS' didn't occur to me. Ill give this a shot and report back. Cheers, K

Do you want my table design or are you suggesting on a way to discover how to write the query? I've been fiddling with this for quite some time. I have kind of diluted the issue a bit to try to get to the basics of writing the query to select the most recent date of each distinct trip part...

Yes access vba using linked tables to mysql.

Hello all, I'm having trouble creating a MySQL query that will pull the data that I need into a recordset. I've designed an application that tracks transit routes. There is table 'tripslog' that logs the route name [tripName], [startTime], [end time], [changeType] ('NEW', 'CHG', or 'DELT')...

June7, encasing the 2018ESY in brackets solved the problem. I wonder why it was necessary to bracket that table but not other tables? I guess you're right as well that it is not necessary to include the table prefix when listing the fields. Thanks for your quick help! I try not to come...

I have the following query to union three separate Excel File local linked tables into one query result. SELECT regtrips.[Name] As tripName, regtrips.[Schools] As schools, regtrips.[Number Stops] As numStops, regtrips.[Number Assigned] As numAssigned, regtrips.Duration as [duration]...

Thanks all! It was the wild card character (should have been * not %). What a stupid mistake! Really appreciate the extra sets of eyes!

Hello, I have an app that is tallying transit information for dynamic invoice generation. I have a table of 'trips,' which is essentially an audit table, showing all values for each tripName key over time. The important fields are tripName and lastUpdate. My program logic is like this...

Thank you, Doc Man, for the advice. Of course now that you mention it, that makes perfect sense. Both sides should be type converted to CSTR. Tried that and I am still getting the same generic error, [my database name] was unable to export the data. The file is created in the destination...

No. Like I said the school code in one of the tables is of type short text since in the base linked excel it is formatted that way. I was trying to cast it as a number so that I could do the comparison and return where they are not equal. I will play around a little more with this and...

Thank you everyone for your thought and responses. First suggestion, using CLNG on both sides of the criteria expression gives me a datasheet table of 2537 records but still gives the non coded error message, "[mydatabase] was unable to export the data." Regarding spaces in column names: Yes...