Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andrew.vint
Starting Member
2 Posts |
 Posted - 2006-05-23 : 03:37:37
|
| Hi,I am currently going through the process of upgrading an Access database to an Access ADP file to hopefully reap the benefits of using the SQL server properly.However one of the issues I am not sure about is with Import Specifications.In Access databases you could save these specifications and use code to import a CSV file. An example of that code is shown below;DoCmd.TransferText acImportDelim, "CSV Agent Import Specification", "Agent Daily", "C:\MI\CSV\PA_AgentReport_" & TheDate & ".csv", False, ""Now that I have upsized it has become clear that the specification CSV Agent Import Specification is not available, it is also not possible to create it again and save it as the save as box is greyed out.Could i please ask if anyone out there knows how i go about getting the same result while keeping in line with ADP paramaters.This would be of great help to me so Thanks in advanceAndrew Vint |
|
|
|
|
|
Import Specifications in ADP File