Thanks, I have linked/imported tables as i desired but still the problem is whenever i import tables again and again, Access create create another tables with the same succeeding with 1,11 and so on while remaining old imported tables. I tried to delete records from old imported tables but no effect in creation of new table every time i click import.
Is it possible to replace the old imported table by the new table with the same name???
Farah Siraj
Last Activity: Mar 20 '14, 11:54 AM
Joined: Nov 26 '10
Location:
-
Farah Siraj replied to how to use Single link specification for multiple different headers tables in Accessin AccessSorry by mistake, i posted objFile.Name instead of objFile.Path
My Question is that i want to link no. of txt files in access but all the txt files have different no. of headers. If i save a specification and use the spec in docmd.transfert ext command so code works but its messing all the linked tables in the way that all linked tables got the same headers as the file ( i linked for making specification) has.
I tried also to link leaving...Leave a comment:
-
Farah Siraj started a topic how to use Single link specification for multiple different headers tables in Accessin Accesshow to use Single link specification for multiple different headers tables in Access
Hi,
I want to link multiple .txt files of different columns in access via VBA. I have made link spec named as " GCELL_Specifica tion" and using the following code.
The problem is Access is making same headers in all linked files as the headers of Spec. Its messing all the linked files. Can anyone tell me how to use a single spec in linking multiple tables of different headers.
Or can anyone tell me how to link... -
Code is not running while reading large values from excel
I have written the javascript code for client side using Google Map API that is running well when i am reading excel sheet having 170 rows but when i tried to run it on excel having 237 rows so it gives error in the array "farah[...]5 is null or not an object",then i ok to debugg but debugger doesn't show anything and map opens but as i want to plot polygon doesn't appears.The same code is showing polygons well for excel of 170 rows....Last edited by Dormilich; Nov 26 '10, 03:00 PM. Reason: please use [CODE] [/CODE] tags when posting code
No activity results to display
Leave a comment: