rahmansaputra,
+ Hello and welcome.
+ It's very hard to follow your question. Are you trying to export data to an SQL-Server?
If this is your question, please take a look at:
home > topics > microsoft access / vba > insights > methods of connecting to sql server
+ Please understand, many of us cannot or will not d/l un-requested attachments. In
my case, such d/l are prohibited by my ITSec staff. A practical example as to why can be found here
http://bytes.com/topic/access/answer...l-ms-products. this unfourtunate Member opened a file from a trusted source that resulted in all sorts of issues!
We encourage, instead of attachments, that code and SQL scripts be posted in-line and formatted using the
[CODE/] tool, for examples of data (the
[CODE/] tool will help hold formatted tables :) ) and a description of what one is attempting and what is actually happening.
However, even then, occasionally, a picture is worth a thousand words, those images should be attached using the [Advanced] posting method - third party sites are often not available to our experts. :)