Search results

yes i did the same

Yes, I tried acLink but again I have the truncation to some fields. not work well.

It doesn't let to choose *.XLSX format ..!! my import files are excel format nor CSV .

My question was related to the VBA coding of this process . make it Automatically.

thanks for your advices ,So I can add Dim td As TableDef so how can I call it to be filled with my excel files ?

thanks which Access version has this advance option. I am on the 365 version and don't have it. I want to add this specification and call in importing Docmd...how can find it and add

Hello I am new in VBA, I have a scenario to import 3 excel files that have the same sheet name ( all 3 have "Report details" sheet) , I want to open a dialog box and choose 3 excel files at the same time and then make a copy in a folder of them .and then import all 3 sheets in ONE table . what...

Thank you for your advice. I am very new to VBA. If I link CSV to the database .it will be truncated to 255 automatically ?!! the only way was not truncated when I import it manually and change those fields datatype to long text .how can I change it to VBA coding or importing or linking...

Hi I am trying to import an Excel sheet to access table and i find the comments section being truncated.I changed the data type in table to long text ( Rich text) .but it truncates less than 255 char. My DATA table has two fileds with longtext( Rich Text) datatype. can you tell me which part of...

Hello I have a table in oracle and I linked it to my access. then I can open it and see data. I created a simple query to see records with the criteria "del" in one field, the below error comes up when I run the query !!!! Could you help me with what would be this issue? ODBC -- call failed...

It was solved .thanks

I need to run it one time .to update the second records with task_ID_1 to make task Id be unique. I have just Copy all duplicated records in a table which are about 800 records. ex: N/A-NJA_2016-05_01163 N/A-NJA_2016-05_01163-1

Thanks for your reply 1- I have just one duplicated ..( It seems the records are different but the important and unique field has been duplicated ) as you see the Availibility ID is diffrent and unique. i just need to add "-1"add the end of duplicated task_id field Thanks

Hello I need your help, I have a table in which some records have been duplicated .based on one field ( ex. Id ) I need to change the duplicated Id ( ex . add -1 at the end of it ) how can I do it in a query? how can ask to find the duplicated records and change the id ? thank you in advance

It didn't accept any changes ... a bunch of errors comes up... I think the issue is with library references and Access 365 new update. I don't know how to solve it..!!!!! i added somee references but .....

Thanks,I am a new in VBA . How can i find the broken library ? I added Option Explicit Still have error on this line

it does highlight varFile

so how can I solve this issue ,..I am not sure to get what to do

Hello I need your help ,I had the below code for Export 3tables in Xl format in a folder .it was working perfectly ,but after updating Access 365 I have runtime error 91.. in the line " For Each varFile In .SelectedItems "... can you help me to solve it .thanks alot Public Function export()...