Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-05-2014, 05:49 PM
macropod's Avatar
macropod macropod is offline insert database as field Windows 7 32bit insert database as field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,518
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try something along the lines of:

{DATABASE \d "C:\\Statement\\Datasource.xlsx" \s "SELECT [Client Billing Document Number] AS [No Doc], FORMAT([Invoice Date], \"dd/MM/yyyy\") AS [Fecha Doc], FORMAT([Due Date], \"dd/MM/yyyy\") AS [Vencimiento], FORMAT([Client Document Currency Balance], \"##,###,##0.00\") AS [Importe], [Client Document Currency] AS [Moneda] FROM [Data$] WHERE [Debtor Number] = \"50010117\" ORDER BY [Invoice Date], [Due Date]" \l "37" \b "51" \h}

Depending on how your data are defined, you may also need to change [Data$] to [Data\$].
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
insert database as field VBA to insert field references SaneMan Word VBA 2 11-01-2013 02:38 AM
insert database as field Template field to insert picture from default location LittleCrunch Word 1 10-28-2013 03:50 AM
MACRO - Insert row based on Form Field Criteria Elan05 Word VBA 5 04-16-2013 06:39 AM
insert database as field little database gsrikanth Excel 3 06-29-2012 05:23 AM
insert database as field Insert "must complete" text field Markw Word 5 11-19-2009 08:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft