In older versions of Access (2003) there used to be an Advanced button presented during the export wizard that allowed you to select and edit an existing specification. I no longer see this feature in Access 2010. I need to modify the specification to eliminate quotes. The file is being exported as an Excel csv file.
Here is the code on a button:
Private Sub Command124_Click()
DoCmd.TransferText acExportDelim, “DEPTSpecification”, “DEPT_Employees per Dept”, “C:\” & “DEPT-” & Format(Now, “YYYYMMDD”) & “.csv”, True
DoCmd.OpenTable “DEPT_Employees per Dept”
End Sub
Tag Archive | "c amp"
Does Anyone Know How To Modify An Existing Export Specification In Microsoft Access 2010?
Posted on 23 August 2011.
Posted in Affiliate Marketing 101Comments (0)
Poll:which Backpack Is Your Favorite?
Posted on 14 August 2011.
http://www.shoponeillusa.com/product/Accessories/Backpacks/CALDER/pc/678/c/0/sc/722/214788.uts
http://www.revolveclothing.com/DisplayProduct.jsp?product=BRAN-WY4&c&d=Handbags¤cy=USD&source=shopstyle
http://www.urbanoutfitters.com/urban/catalog/productdetail.jsp?itemdescription&itemCount=80&startValue=241&selectedProductColor&sortby&id=20394748&parentid=W_ONLINEEX&sortProperties=+subCategoryPosition%2C+product.marketingPriority&navCount=35&navAction=jump&color&pushId=W_ONLINEEX&popId=WOMENS&prepushId&selectedProductSize&cm_mmc=Performics-_-Affiliates-_-ShopStyle.com-_-Primary&clickid=0004aa08ef4f077b0ae0d2c2376579ef
first one in black w/ flowers
last one in tan/grey/white
Posted in Featured ArticlesComments (0)