Search results

well the amount of columns and rows will change, depending on how many entries are made in the file im importing. Also the field names are being imported so field 3 could have a random name like "20387b1" and field 4 "25367b1". So im pretty clueless how to approach this. I'm sure this is...

because im unsure how to make a query for data that is going to change.. each time the file is imported its going to be different, so how to i query if the cells are changing?

because im unsure how to make a query for data that is going to change.. each time the file is imported its going to be different, so how to i query if the cells are changing?

because the data i want to query is going to change so i dont know how to query it.

hello, i have compiled some code that enables the user to click a command button, which opens a dialogue box allowing the user to select a .csv file which is then automatically imported into a table. While its in this table i want to run queries on it. Does anyone know the code for manually...

yes yes it allowed me to find the file and click ok, it then told me the name of the file i had selected. But after this it would debug.

right when i hover over the code a box appears saying myvariable="" which makes me think im obviously missing something important. Yet im completely clueless to what it is.. any ideas??

again this line was lit up DoCmd.TransferText acImportDelim, "", "tblImportTableTest", MYVARIABLE, False, "" but this time i got the error: The action or method requires a file name arguement Any idea what that means?

again this line was lit up DoCmd.TransferText acImportDelim, "", "tblImportTableTest", MYVARIABLE, False, "" but this time i got the error: The action or method requires a file name arguement Any idea what that means?

my code works Yeah what i mean is my code works and allows the user to browse. Its the DoCmd.TransferText acImportDelim,... is the problem. MYVARIABLE should be an actual variable but i dont know where im declaring it

ur code has varFileName, the purpose of my code was to give the user a choice of file and then import it. What is the purpose of the code you just linked me to? does it import to a database table? thanks, Marley.

Hello, im trying to make a command button that once clicked imports a .csv file into a table, applies queries and creates a report. So far i have.. ***************Command button**************** Private Sub Command0_Click() Dim strFilter As String Dim lngFlags As Long strFilter =...

I have made a button and right clicked, I set the on click command as "DoCmd.TransferText", but i dont understand how to reference the form to the command.

Hello, i want to make a button on my form to input .csv files. What is the best way to do this? I simply want to click the button and be asked for the csv location, i want the csv to be imported and be formatted. Whats the best way to do this?